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

1 vote221 views4 answers
Get week day from date in sql
SQL
-2 votes206 views2 answers
Union vs union all in sql
SQL
0 vote212 views1 answer
Mysql drop vs delete
SQL
0 vote264 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
5 votes203 views3 answers
Oracle list columns in schema
SQL
0 vote216 views1 answer
Cube oracle
SQL
1 vote226 views1 answer
Hangfire clear all jobs
SQL
13 votes195 views2 answers
Sql count distinct group by
SQL
7 votes205 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL
0 vote224 views1 answer
Difference between 2 query results sql server
SQL