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

5 votes227 views3 answers
Mysql update field from one table to another
SQL
2 votes215 views1 answer
Get first 3 letters name in sql
SQL
0 vote517 views1 answer
Create pl/sql stored procedure
SQL
1 vote227 views1 answer
Create index concurrently postgres
SQL
1 vote219 views2 answers
Difference between in and between in sql
SQL
0 vote224 views1 answer
Sql select non unique
SQL
0 vote235 views2 answers
Select columns from 2 tables with foreign key
SQL
0 vote244 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
0 vote255 views1 answer
Error code 1241 mysql
SQL
5 votes248 views6 answers
Sql foreign key
SQL