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

11 votes156 views1 answer
Oracle export view ddl
SQL
4 votes94 views1 answer
And or sql order of operations
SQL
1 vote161 views1 answer
Sql query row number group by
SQL
49 votes203 views6 answers
Alter table add column
SQL
0 vote160 views2 answers
Drop tables from local table database postgres
SQL
0 vote147 views1 answer
Ms sql filter all sympbol
SQL
0 vote139 views1 answer
Sql server select value large text
SQL
0 vote123 views1 answer
Call procedure in wordpress
SQL
2 votes141 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote133 views1 answer
Min mysql
SQL