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

1 vote223 views1 answer
Postgres install unaccent extension
SQL
0 vote194 views1 answer
Mysql select all table that have field names
SQL
0 vote224 views1 answer
Function sum(text) does not exist postgres
SQL
0 vote214 views1 answer
Hibernate dialect property xml for mysql 8
SQL
0 vote217 views1 answer
Pass array parameter to stored procedure c#
SQL
0 vote225 views1 answer
Oracle insert single quote in string
SQL
0 vote179 views1 answer
Hangfire clean script
SQL
0 vote223 views1 answer
Excel vba import data to sql server
SQL
1 vote201 views1 answer
Sql restore backup query
SQL
0 vote187 views1 answer
Where case insensitive like mysql
SQL