Sql limit to 5 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

Similar codes

1 vote226 views1 answer
Mysql check string don't have number
SQL
1 vote163 views1 answer
Oracle compile schema
SQL
8 votes206 views1 answer
Oracle add month
SQL
2 votes210 views1 answer
Import database in mysql command line xampp
SQL
1 vote228 views1 answer
Sql server loop over query
SQL
4 votes211 views1 answer
Select first and last row sql
SQL
9 votes245 views3 answers
Postgres make sql dump
SQL
0 vote217 views1 answer
Sintaxis SELECT sql
SQL
6 votes231 views3 answers
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.term.year' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
5 votes178 views1 answer
Alter table default value mysql
SQL