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 vote109 views1 answer
My sql data file extention
SQL
0 vote138 views2 answers
Sql unique
SQL
0 vote137 views1 answer
Run docker container with database as rds metabase
SQL
0 vote109 views1 answer
Oracle remove line breaks
SQL
2 votes98 views2 answers
Spring import sql
SQL
0 vote113 views1 answer
Get last date join sql
SQL
-1 vote112 views1 answer
Concat two columns in sql server
SQL
23 votes97 views6 answers
How to create table in sql
SQL
0 vote98 views1 answer
Convert rows to columns in sql server
SQL
0 vote106 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL