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 vote169 views1 answer
Mysql update privileges
SQL
0 vote193 views1 answer
Transaction and commit trong sql server
SQL
1 vote169 views1 answer
Rows to comma separated values in mssql
SQL
0 vote158 views6 answers
Unique key in sql
SQL
0 vote160 views1 answer
How to count with except in psql
SQL
0 vote195 views1 answer
How to print some string in mysql
SQL
0 vote327 views1 answer
Sql change a colum to unique
SQL
1 vote160 views1 answer
Set all the vluses in calumn in sql to false
SQL
0 vote171 views1 answer
Sql auto_increment syntax
SQL
0 vote164 views1 answer
Add column to table with default value plsql
SQL