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 vote331 views1 answer
Run mssql server terminal
SQL
0 vote343 views1 answer
Proc sql not in working
SQL
6 votes320 views2 answers
Mysql first day of month
SQL
0 vote333 views1 answer
Php select data from mysql database without column name
SQL
1 vote352 views1 answer
Mysql curdate between two dates
SQL
1 vote327 views1 answer
Set all the vluses in calumn in sql to false
SQL
0 vote369 views1 answer
Space not removing from column in sql
SQL
0 vote340 views1 answer
How to to get time in sql
SQL
5 votes351 views2 answers
Postgresql insert select
SQL
0 vote331 views1 answer
Alter fedora mysql 8.0 user
SQL