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 vote383 views1 answer
How to select all fieldsin a soql query
SQL
0 vote350 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
2 votes355 views1 answer
Grant revoke privileges to mysql username
SQL
5 votes347 views2 answers
Mysql date greater than 30 days
SQL
0 vote347 views1 answer
Alter owner in PostgreSQL
SQL
5 votes361 views2 answers
Mysql create database charset utf8mb4
SQL
0 vote342 views1 answer
Sql server is not
SQL
0 vote342 views1 answer
Mysql docker image for macbook m1
SQL
2 votes342 views1 answer
Drop table if exists in postgres
SQL
0 vote358 views1 answer
Create tables from xsd to sql server database c#
SQL