Sql limit results returned

-- 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 vote118 views1 answer
Sql stored procedure update if parameter is not null
SQL
0 vote97 views1 answer
Faire une recherche par liste de mot clé sql
SQL
0 vote119 views1 answer
Get who is hired in february in sql
SQL
1 vote115 views1 answer
Does insert into overwrite sql
SQL
0 vote114 views1 answer
Import excel to sql
SQL
-1 vote121 views3 answers
Error: mysql shutdown unexpectedly.
SQL
0 vote104 views1 answer
Mysql add text to existing field
SQL
0 vote111 views4 answers
How to connect form to database
SQL
0 vote105 views1 answer
Oracle list index on table
SQL
15 votes114 views3 answers
Create table with primary key auto increment in sql
SQL