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 vote358 views1 answer
Proc sql not in working
SQL
19 votes350 views5 answers
Mysql between date range
SQL
1 vote345 views2 answers
Mysql trim whitespace
SQL
0 vote350 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
0 vote359 views5 answers
How to make trigger in phpmyadmin
SQL
0 vote307 views3 answers
Mysql calculate age from date of birth
SQL
0 vote347 views2 answers
How to check if sqlite table exists in nodejs
SQL
0 vote340 views2 answers
Postgresql get last day of month
SQL
0 vote332 views4 answers
Sql year
SQL
0 vote345 views1 answer
Postgres reorder columns
SQL