Horje
sql limit to 5 results Code Example
sql limit to 5 results 
-- MySql
SELECT * FROM emp ORDER BY sal DESC LIMIT 5;	
-- SQL Server 
SELECT TOP 5 * FROM emp ORDER BY sal DESC;	
-- Oracle < 11g 
SELECT * FROM ( SELECT * FROM emp ORDER BY sal DESC ) WHERE ROWNUM <= 5;
-- Oracle 12c +
SELECT * FROM emp ORDER BY sal DESC FETCH FIRST 5 ROWS ONLY;
sql limit to 5 results 
SELECT expressions
FROM tables
[WHERE conditions]
[ORDER BY expression [ ASC | DESC ]]
LIMIT number_rows [ OFFSET offset_value ];
Source: www.techonthenet.com



Sql

Related
join in update query in mysql Code Example join in update query in mysql Code Example
postgre query date Code Example postgre query date Code Example
postgres extract date from timestamp Code Example postgres extract date from timestamp Code Example
opening xampp mysql in cmd ubuntu Code Example opening xampp mysql in cmd ubuntu Code Example
psql check tables command Code Example psql check tables command Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 6



 

Horje