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 vote297 views0 answer
SQL
8 votes347 views2 answers
Oracle auto increment primary key
SQL
0 vote324 views1 answer
Mysql get 2nd value in comma separated list
SQL
0 vote341 views1 answer
Sql server separar numeros por comas miles
SQL
4 votes348 views6 answers
Second max salary in sql
SQL
0 vote343 views1 answer
Mysql master slave setup with keepalived
SQL
0 vote380 views1 answer
Mysql date equals to current_date plus days
SQL
8 votes368 views2 answers
Update sql server from another table
SQL
1 vote331 views2 answers
Update with inner join sql server
SQL
0 vote321 views1 answer
Mysql xampp reset root password
SQL