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

1 vote344 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
1 vote376 views1 answer
Oracle extract minute from date
SQL
0 vote382 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
1 vote346 views1 answer
Apex select list ORA-20999
SQL
0 vote360 views1 answer
Creation d'un trigger sql
SQL
1 vote349 views1 answer
Add current timestamp in mysql
SQL
0 vote328 views1 answer
Create table employees oracle
SQL
0 vote364 views1 answer
Case insensitive sql
SQL
0 vote354 views1 answer
Alter database name script
SQL
0 vote348 views1 answer
Oracle sql procedure return value
SQL