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 vote119 views1 answer
Drop all triggers oracle
SQL
0 vote119 views1 answer
Insert set mysql
SQL
1 vote430 views1 answer
Mysql event last execution
SQL
3 votes116 views3 answers
Sql last week
SQL
1 vote109 views1 answer
Set mysql mode global query
SQL
0 vote75 views2 answers
Avg() sql
SQL
4 votes80 views2 answers
Create table if not exists postgres
SQL
1 vote113 views1 answer
Get url of cpanel database hostname
SQL
0 vote126 views1 answer
Hour and minute between two datatime sql
SQL
0 vote119 views1 answer
Create a view in sqlite
SQL