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

1 vote152 views1 answer
Oracle duration between timestamps
SQL
19 votes149 views2 answers
Mysql tinyint max value
SQL
1 vote179 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
6 votes150 views1 answer
Update left join mysql
SQL
0 vote153 views1 answer
H2 auto increment and unique
SQL
0 vote156 views1 answer
How to create a new shema using query languaage
SQL
0 vote167 views1 answer
Is not numeric sql
SQL
0 vote138 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
0 vote176 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
1 vote150 views2 answers
Postgresql get difference in hours between two dates
SQL