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 vote305 views1 answer
Create new table pl sql
SQL
2 votes309 views3 answers
How to get second highest salary in each department in sql
SQL
0 vote357 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
0 vote277 views2 answers
Spring properties file for db
SQL
1 vote341 views3 answers
Postgresql get difference between two dates
SQL
1 vote323 views1 answer
Get table column names sql ssms
SQL
1 vote318 views1 answer
Mariadb case switch
SQL
1 vote322 views1 answer
Load mysql dumb
SQL
1 vote314 views2 answers
Mysql remove first and last character from string
SQL
0 vote346 views1 answer
Query builder doctrien return sql
SQL