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

0 vote283 views1 answer
Psql no such file or directory
SQL
0 vote304 views1 answer
Pass array parameter to stored procedure c#
SQL
0 vote303 views1 answer
How to insert multiple rows in mysql using laravel
SQL
0 vote301 views1 answer
Incorrect datetime value sql table error 1292
SQL
9 votes330 views3 answers
Postgres make sql dump
SQL
0 vote275 views1 answer
Linux upload database to mysql
SQL
0 vote318 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
0 vote324 views1 answer
Oracle table privileges
SQL
0 vote292 views1 answer
Python mysql executemany
SQL
5 votes303 views2 answers
Get columns number sql
SQL