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

15 votes237 views4 answers
Mysql export database command line
SQL
0 vote255 views1 answer
Postgre query date
SQL
0 vote246 views1 answer
Postgres can integer fields be negative
SQL
15 votes237 views4 answers
Create table if not exists sql
SQL
1 vote229 views3 answers
Showing all columns in an sqlite table
SQL
2 votes210 views1 answer
Sql select min value from multiple columns
SQL
1 vote270 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
6 votes246 views3 answers
Oracle all dates between two dates
SQL
46 votes238 views4 answers
Create column sql
SQL
1 vote226 views3 answers
Mysql disable foreign keys check
SQL