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 vote220 views1 answer
Mysql pad zeros
SQL
1 vote226 views2 answers
Grab part of a string sql
SQL
5 votes263 views3 answers
Create function in postgresql
SQL
3 votes221 views1 answer
Postgresql db owner change
SQL
0 vote229 views1 answer
Creating a simple notify in postgresql
SQL
7 votes233 views1 answer
Buy forge mods server hosting
SQL
0 vote227 views1 answer
Mysql subtract month from timestamp
SQL
6 votes243 views6 answers
Rename column postgres
SQL
-1 vote217 views1 answer
Sql set max value in column
SQL
0 vote213 views1 answer
Uuid sqlalcomany
SQL