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

20 votes283 views3 answers
SQL query rename table
SQL
1 vote333 views1 answer
Delete dublicate rows sql
SQL
7 votes287 views3 answers
Sql fill table with info from anothe rtable
SQL
0 vote314 views1 answer
Creating sqeuence in oracle database
SQL
0 vote288 views1 answer
Mariadb search columns
SQL
9 votes291 views3 answers
Mysql show table column full description
SQL
0 vote328 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
0 vote260 views1 answer
Java mysql date format
SQL
2 votes308 views1 answer
Alter table add column and foreign key mysql
SQL
1 vote265 views1 answer
Delete mysql from mac
SQL