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 vote133 views1 answer
Mysql check string don't have number
SQL
15 votes130 views2 answers
Install mysql 8 ubuntu 18.04
SQL
0 vote142 views1 answer
Oracle sql copy table without data
SQL
0 vote140 views1 answer
Cartesian product sql
SQL
0 vote142 views1 answer
Not equal to blank in mysql
SQL
0 vote135 views1 answer
Sql query interview questions githu
SQL
3 votes159 views1 answer
Oracle function return
SQL
1 vote132 views1 answer
Mysql get character set
SQL
31 votes173 views4 answers
Mysql grant execute
SQL
0 vote135 views3 answers
Get free card roblox
SQL