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 vote144 views1 answer
Mysql join column order By and group By
SQL
0 vote140 views1 answer
Download mysql database to excel in android studio
SQL
0 vote136 views1 answer
Selecting duplicates
SQL
0 vote93 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
0 vote142 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
2 votes166 views3 answers
How to replace null values in sql
SQL
0 vote87 views1 answer
Update row in sqlite python
SQL
0 vote131 views1 answer
Groupby error in mysql
SQL
1 vote96 views1 answer
Mysql show attributes of a table
SQL
1 vote134 views1 answer
Incompatible sql_mode=only_full_group_by
SQL