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

5 votes168 views2 answers
Mysql create database charset utf8mb4
SQL
0 vote145 views5 answers
Linq cheat sheet
SQL
0 vote183 views1 answer
Isnull in sqlite
SQL
0 vote150 views1 answer
Mysql foreach insert
SQL
0 vote158 views1 answer
Reset keys in sql
SQL
0 vote144 views1 answer
How many columns can be used for creating index?
SQL
25 votes145 views6 answers
Import mysql database command line
SQL
-1 vote153 views1 answer
Utf8_encode mysql
SQL
0 vote144 views1 answer
Downgrading sql localdb visual studio
SQL
1 vote156 views1 answer
SQL date part only of datetime
SQL