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

2 votes274 views2 answers
Python escape string for sql
SQL
0 vote230 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote235 views1 answer
Tsql generate rows
SQL
0 vote257 views2 answers
Wordpress change url after migration mysql query
SQL
1 vote240 views2 answers
T sql get foreign key
SQL
22 votes239 views4 answers
Mysql date format
SQL
4 votes732 views1 answer
Oracle show errors
SQL
0 vote244 views1 answer
Windows aggregate functions in postgresql
SQL
21 votes253 views1 answer
Cheatsheet for sql
SQL
1 vote221 views1 answer
GROUP BY clause; this is incompati
SQL