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 vote224 views1 answer
Drop a view in sqlite
SQL
0 vote207 views1 answer
Select last 2 characters sql
SQL
0 vote224 views1 answer
Postgres change the name of schema
SQL
1 vote205 views3 answers
Postgresql connect to database
SQL
8 votes211 views3 answers
Oracle auto_increment
SQL
2 votes206 views2 answers
Checking data type in sql server
SQL
5 votes178 views1 answer
Mongodb vs
SQL
0 vote209 views1 answer
Mysql pad zeros
SQL
-1 vote213 views1 answer
Get id from just inserted row mysql server python
SQL
0 vote191 views1 answer
Sql query to check if column contains alphabets
SQL