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 vote137 views1 answer
Components/Fields of Internal Table
SQL
2 votes147 views3 answers
How to get second highest salary in each department in sql
SQL
1 vote137 views1 answer
Mysql count words
SQL
0 vote140 views1 answer
What does leave do in mysql
SQL
0 vote157 views1 answer
Command to give readonly access to a postgres sql user
SQL
0 vote133 views1 answer
Do postgresql
SQL
2 votes180 views1 answer
Username sql
SQL
17 votes135 views6 answers
Sql select distinct
SQL
0 vote138 views1 answer
Sql server select top 2 of each group
SQL
2 votes150 views1 answer
How to delete all duplicate items in mysql
SQL