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

1 vote287 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
0 vote286 views1 answer
Authentication in sql server
SQL
1 vote276 views1 answer
Update and replace mysql
SQL
16 votes323 views3 answers
Get count of duplicate records
SQL
0 vote278 views1 answer
Sql contains vs like
SQL
2 votes279 views1 answer
Sql to char function with date
SQL
0 vote328 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
1 vote278 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
0 vote285 views1 answer
Sql count null values in all columns
SQL
8 votes294 views1 answer
Oracle current date plus 1 month
SQL