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: techonthenet.com

Similar codes

0 vote150 views1 answer
Drop column from local database postgres pgadmin
SQL
8 votes164 views2 answers
Change name of colum in sql table
SQL
1 vote181 views1 answer
Mysql tables max count
SQL
0 vote141 views1 answer
Sql query to delete row by id
SQL
0 vote187 views1 answer
Delet all record statment sql
SQL
0 vote135 views1 answer
Flask sqlalchemy update row
SQL
0 vote154 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote156 views1 answer
Query for backup a database at another location in file system
SQL
0 vote146 views1 answer
Test sql query
SQL
0 vote144 views1 answer
Normalization in database 2nd normal form
SQL