Sql limit 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

Sql limit results

LIMIT 5

Similar codes

0 vote150 views1 answer
Use where instead of join
SQL
1 vote178 views1 answer
Postgres cast as currency format
SQL
0 vote189 views1 answer
Mysql where sum > 0
SQL
-1 vote158 views3 answers
My sql alter table
SQL
10 votes154 views2 answers
Oracle alter sequence nextval
SQL
0 vote138 views1 answer
Oracle DROP PROGRAM
SQL
0 vote160 views1 answer
Rows, INSERT INTO, Returning
SQL
0 vote161 views1 answer
Get schema of table sql
SQL
0 vote202 views1 answer
Copy from one table to another postgres using matching column
SQL
0 vote102 views1 answer
Update row in sqlite python
SQL