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

11 votes186 views1 answer
Mysql text type max length
SQL
0 vote181 views1 answer
Group by two columns postgres
SQL
0 vote186 views1 answer
Sql count more than 1
SQL
1 vote165 views2 answers
Limit sqlserver
SQL
3 votes198 views2 answers
Update Query in SQL Server
SQL
0 vote216 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
4 votes178 views1 answer
Wildcard in sql
SQL
1 vote180 views1 answer
Get url of cpanel database hostname
SQL
1 vote175 views1 answer
Primary key reset in SQL database
SQL
0 vote199 views2 answers
Homebrew nysql launch
SQL