Sql limit order by

-- 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 order by

SELECT expressions
FROM tables
[WHERE conditions]
[ORDER BY expression [ ASC | DESC ]]
LIMIT number_rows [ OFFSET offset_value ];

Source: techonthenet.com

Similar codes

0 vote181 views1 answer
Sql select all tables from database change url
SQL
0 vote181 views1 answer
ORA-13717
SQL
1 vote197 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
0 vote200 views1 answer
Datagrip execute procedure
SQL
0 vote207 views1 answer
Mysql conf.d exampel
SQL
1 vote167 views1 answer
Deleting database in sql
SQL
6 votes195 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
0 vote182 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL
5 votes160 views2 answers
Oracle list columns schema
SQL
0 vote184 views1 answer
Mariadb select limit offset
SQL