Sql limit 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

Sql limit results

LIMIT 5

Similar codes

0 vote307 views1 answer
Sql add calculated column
SQL
0 vote294 views1 answer
Mysql installer no packages found
SQL
1 vote290 views1 answer
How to see all table partition in oracle
SQL
7 votes273 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL
0 vote354 views1 answer
Pl sql join 3 tables
SQL
2 votes300 views1 answer
Oracle index size calculation
SQL
0 vote373 views1 answer
Python get backup of sql
SQL
0 vote293 views2 answers
Find Overlapping sql
SQL
1 vote296 views1 answer
Trigger in postgresql to change incoming entry
SQL
1 vote320 views1 answer
Create new index takes long time postgresql
SQL