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 vote228 views1 answer
Postgresql not in alternative
SQL
0 vote233 views1 answer
How to move a column to different spot mysql
SQL
5 votes219 views1 answer
Ascending order and where in sql
SQL
3 votes238 views3 answers
Order by postgres
SQL
0 vote227 views2 answers
How to update date in oracle
SQL
0 vote226 views1 answer
Sql server order by nulls last
SQL
0 vote225 views1 answer
Sql find leading space
SQL
1 vote233 views1 answer
Pagination sql
SQL
0 vote235 views1 answer
Sql server roles and users
SQL
0 vote228 views3 answers
Find below average salary in sql
SQL