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 vote331 views1 answer
T sql return on letters only
SQL
1 vote364 views1 answer
Oracle check table lock
SQL
0 vote354 views1 answer
Sql server check whether column has same equal values
SQL
0 vote391 views1 answer
What is delimiter in mysql
SQL
0 vote682 views1 answer
Create pl/sql stored procedure
SQL
2 votes390 views1 answer
How to check if a row is null in sql
SQL
1 vote447 views1 answer
Difference between where and having clause
SQL
1 vote338 views1 answer
Oracle check table space
SQL
0 vote368 views1 answer
Renommer base sql
SQL
1 vote361 views1 answer
Mysql check table exists
SQL