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 vote282 views1 answer
Delete all rows from table sqlite
SQL
0 vote338 views1 answer
Sql string contains case sensitive
SQL
6 votes328 views2 answers
Oracle
SQL
0 vote322 views1 answer
Insert array into mysql column
SQL
1 vote320 views1 answer
Oracle index partition
SQL
16 votes357 views5 answers
Select last row in sql
SQL
1 vote285 views1 answer
Alter user mysql native password
SQL
0 vote351 views1 answer
SQL check if record exist
SQL
7 votes339 views1 answer
Sql server management studio turn on line numbers
SQL
1 vote316 views1 answer
Loading local data is disabled mysql
SQL