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

0 vote220 views1 answer
SQL Cut part string
SQL
24 votes188 views4 answers
Mssql get all table names
SQL
1 vote135 views1 answer
Python escape string for sql
SQL
1 vote182 views1 answer
Md5 encryption for existing records
SQL
-1 vote199 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
1 vote173 views1 answer
How much every mysql database record takes from diskspace
SQL
0 vote183 views2 answers
Mysql dump database tables only
SQL
0 vote243 views1 answer
Alter database name script
SQL
0 vote185 views1 answer
Java nosql sort
SQL
15 votes185 views4 answers
Create table if not exists sql
SQL