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 vote340 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
0 vote311 views1 answer
Version and edition of SQL Server Database Engine
SQL
0 vote351 views1 answer
Select count concat string sql server
SQL
2 votes334 views2 answers
Sql first character
SQL
4 votes365 views1 answer
How to drop a database in sql server when it is in use
SQL
2 votes329 views1 answer
Columns Present in a table
SQL
6 votes373 views3 answers
Psql show columns of table
SQL
-1 vote328 views3 answers
Mysql get age from date
SQL
1 vote321 views1 answer
Oracle explain plan
SQL
0 vote314 views1 answer
Sql count null as 0
SQL