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 vote272 views1 answer
Mysql select random rows large table
SQL
3 votes170 views1 answer
Pl sql check if variable is empty
SQL
0 vote191 views1 answer
Sql values that contains certain multiple ids
SQL
0 vote199 views2 answers
How do I install microsoft SQL on my Mac?
SQL
0 vote169 views1 answer
How to get initials in sql
SQL
0 vote182 views1 answer
Mysql earlier than date
SQL
0 vote209 views1 answer
MySQL import data from large CSV file
SQL
1 vote223 views1 answer
Find difference in dates sql
SQL
4 votes177 views1 answer
Delete record mysql query
SQL
1 vote216 views1 answer
Sql select table header
SQL