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 vote204 views1 answer
Postgresql isnull with max
SQL
6 votes186 views1 answer
Phpmyadmin reset root password
SQL
2 votes194 views1 answer
Mysql sysdate - 1 day
SQL
2 votes278 views2 answers
Set value to null sql
SQL
0 vote190 views1 answer
Alter table myisam to innodb
SQL
0 vote247 views1 answer
Sqlite trim
SQL
1 vote176 views1 answer
Sql delete row with auto increment
SQL
0 vote189 views1 answer
Sauvegarde complète my sql
SQL
2 votes183 views1 answer
Get first 3 letters name in sql
SQL
7 votes187 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL