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

7 votes124 views1 answer
Oracle set sequence value to max(id)
SQL
0 vote118 views1 answer
Uninstall mysql ubuntu 18.04 stackoverflow
SQL
0 vote191 views1 answer
Postgresql powershell query
SQL
0 vote93 views1 answer
Create duplicate table postgres
SQL
1 vote123 views1 answer
Best configuration for display table in sqlplus
SQL
0 vote119 views1 answer
View acl table oracle
SQL
2 votes132 views1 answer
Mariadb select multiple rows into one column
SQL
3 votes140 views1 answer
How to uninstall microsoft sql server
SQL
0 vote127 views1 answer
Get record which is available in one table but not in another mysql
SQL
0 vote136 views1 answer
PGSQL dynamic table name
SQL