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

7 votes328 views1 answer
Oracle alter sequence restart start with
SQL
2 votes332 views1 answer
Mysql id of inserted row
SQL
24 votes325 views5 answers
List mysql users
SQL
0 vote304 views1 answer
Mysql coonect sample code
SQL
0 vote317 views1 answer
Database db connection string format
SQL
2 votes302 views1 answer
Sql server conection string
SQL
0 vote333 views1 answer
Postgres list users and roles
SQL
6 votes321 views1 answer
Oracle rank
SQL
0 vote330 views1 answer
Gcloud sql instance list
SQL
2 votes300 views1 answer
Plsql block
SQL