Sql limit to 5 results

-- 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;

Sql limit to 5 results

SELECT expressions
FROM tables
[WHERE conditions]
[ORDER BY expression [ ASC | DESC ]]
LIMIT number_rows [ OFFSET offset_value ];

Source: techonthenet.com

Similar codes

0 vote178 views1 answer
Capabilities of sql select statements
SQL
0 vote210 views1 answer
<sql:datasource var="Snapsho"
SQL
4 votes140 views1 answer
Refresh postgres config
SQL
0 vote145 views1 answer
How to find table lock and row lock in mysql
SQL
6 votes214 views1 answer
Sql insert values into table
SQL
5 votes157 views3 answers
Show indexes mysql
SQL
4 votes140 views2 answers
Postgresql default value
SQL
0 vote147 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
0 vote135 views2 answers
Mysql select date from datetime
SQL
0 vote126 views2 answers
Update information in a mysql column
SQL