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

5 votes178 views1 answer
Oracle sysdate - 1 month
SQL
1 vote158 views2 answers
T-sql random number for each row
SQL
0 vote160 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
2 votes174 views1 answer
How to delete view in sql
SQL
5 votes170 views3 answers
String concatenation sql server
SQL
0 vote181 views1 answer
Print mysql
SQL
0 vote173 views1 answer
Renommer base sql
SQL
9 votes193 views3 answers
Find all tables with column name
SQL
0 vote173 views1 answer
Sql convert datetime to year
SQL
0 vote165 views1 answer
Mysql delete from where like
SQL