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 vote132 views2 answers
Mysql get routine parameter list
SQL
3 votes144 views1 answer
Oracle sql commit example
SQL
1 vote147 views2 answers
Sql queries practice
SQL
0 vote139 views2 answers
How to get last inserted id in sql server c#
SQL
0 vote133 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
15 votes155 views4 answers
Mysql export database command line
SQL
0 vote89 views1 answer
How to fetch highest score in minimum time using mysql
SQL
0 vote135 views1 answer
Databricks install odbc driver connect to sql server
SQL
0 vote159 views1 answer
Prisma transaction
SQL
0 vote131 views1 answer
Mysql_num_fields in mysqli
SQL