Mysql limit rows

-- 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;

Similar codes

3 votes244 views1 answer
Get all elements sql
SQL
0 vote276 views1 answer
Linebreak sql
SQL
0 vote328 views1 answer
Plpgsql create function
SQL
0 vote267 views1 answer
MySQL import data from large CSV file
SQL
1 vote237 views1 answer
Full text index mysql
SQL
0 vote297 views1 answer
Oracle string length
SQL
2 votes281 views1 answer
Sql server case sensitive search
SQL
2 votes289 views1 answer
Show max_allowed_packet mysql
SQL
3 votes290 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
0 vote275 views1 answer
Insert output identity
SQL