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 vote193 views1 answer
How to use query in nosql
SQL
1 vote191 views1 answer
Mysql date diff in seconds
SQL
0 vote211 views1 answer
Duplix print in Smartforms
SQL
0 vote195 views1 answer
Get last date join sql
SQL
0 vote193 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
0 vote187 views1 answer
Oracle drop default value
SQL
1 vote236 views1 answer
Default
SQL
2 votes186 views1 answer
Oracle number to percentage
SQL
0 vote159 views1 answer
Sql select rows with simlar names
SQL
0 vote198 views1 answer
Load data from text file to mysql database on mac terminal
SQL