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 vote175 views1 answer
SQL Hello, [firstname] [lastname]
SQL
5 votes189 views2 answers
Oracle rename table
SQL
6 votes139 views2 answers
Spring data jpa application.properties mysql
SQL
2 votes178 views1 answer
Sql update from different table
SQL
1 vote199 views1 answer
Last 24 HOUR data in mysql
SQL
1 vote210 views1 answer
Ubuntu access database from terminal
SQL
0 vote192 views1 answer
Sql select random procentage from rows
SQL
0 vote183 views1 answer
Vbscript connect mssql
SQL
2 votes207 views1 answer
Python sql
SQL
1 vote178 views3 answers
How to get date in sql
SQL