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

2 votes125 views1 answer
Sql OR
SQL
0 vote116 views1 answer
Copy row from db to db mysql
SQL
2 votes121 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
0 vote124 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
0 vote115 views1 answer
Plpgsql if statement
SQL
0 vote115 views1 answer
What is default mysql database password in linux
SQL
0 vote114 views1 answer
Inserting data into different tables at once in oracle sql
SQL
1 vote119 views1 answer
Show per page table in xampp
SQL
5 votes75 views1 answer
Alter table default value mysql
SQL
0 vote112 views1 answer
Mysql identified by syntax error
SQL