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 vote214 views1 answer
Set statiscis on in ssms
SQL
0 vote225 views1 answer
Mysql show create db
SQL
0 vote200 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL
0 vote168 views1 answer
'0000-00-00' for column '
SQL
0 vote257 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
0 vote188 views1 answer
Sql contains numeric characters
SQL
0 vote197 views1 answer
C# mysql data reader from two tables
SQL
0 vote182 views0 answer
SQL
0 vote211 views1 answer
How to list function in psql
SQL
2 votes191 views3 answers
Postgres remove foreign key constraint
SQL