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 vote175 views1 answer
How to make full text search dynamic in mysql
SQL
0 vote125 views1 answer
Oracle sysdba connect as another user
SQL
0 vote189 views1 answer
Shrink database file in sql server
SQL
2 votes199 views1 answer
Capitalize 1st letter in sql server
SQL
4 votes162 views2 answers
Dbms_scheduler stop job
SQL
0 vote203 views1 answer
Bitmap join index
SQL
0 vote170 views1 answer
Sql not exists
SQL
0 vote172 views1 answer
Tsql table column constraint must be uppercase
SQL
6 votes186 views4 answers
Mysql update set
SQL
46 votes178 views4 answers
Create column sql
SQL