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

1 vote180 views1 answer
Base64 encode sql server
SQL
0 vote155 views1 answer
Sql not exists
SQL
1 vote156 views1 answer
Mysql select if empty result
SQL
0 vote140 views1 answer
Timestamp(0) postgresql
SQL
0 vote158 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
0 vote186 views1 answer
Grouping by email domain mysql
SQL
2 votes148 views1 answer
Sql ignore accents
SQL
0 vote223 views1 answer
Sqlalchemy _in array sqlite
SQL
0 vote142 views1 answer
Mysql set column equal to another automatic
SQL
0 vote151 views1 answer
Recursive query herarchical data sql server
SQL