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 vote175 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
0 vote166 views1 answer
Sql random decimal
SQL
0 vote180 views1 answer
If column value is null then in mysql
SQL
0 vote183 views1 answer
Console output pl sql
SQL
0 vote197 views1 answer
Insert ip address in mysql
SQL
0 vote194 views1 answer
Providername system.data. mysql
SQL
0 vote202 views1 answer
Oracle current date minus 1 day
SQL
2 votes191 views1 answer
Mysql change data type of column
SQL
5 votes190 views2 answers
Create function postgresql
SQL
9 votes182 views1 answer
No sql
SQL