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 vote283 views1 answer
Error code 1241 mysql
SQL
6 votes296 views4 answers
Mysql get random row
SQL
1 vote220 views1 answer
Restart identity postgresql
SQL
1 vote266 views1 answer
Deleting database in sql
SQL
0 vote276 views1 answer
Call scalar valued function sql
SQL
2 votes285 views2 answers
Mysql count rows returned
SQL
0 vote245 views1 answer
Sql right characters
SQL
6 votes274 views2 answers
Mysql interval 1 day
SQL
0 vote294 views1 answer
Add timestamp column to existing table t-sql
SQL
0 vote268 views1 answer
Guid string to binary better
SQL