Mysql limit rows

-- 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;

Similar codes

11 votes367 views2 answers
You are using safe update mode
SQL
0 vote342 views1 answer
What is logical database schema
SQL
0 vote380 views1 answer
Sqlalchemy empty table
SQL
0 vote353 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote357 views2 answers
How to create a table from another table in sql derby
SQL
10 votes353 views3 answers
Sql check double value
SQL
20 votes361 views5 answers
Sql show tables
SQL
0 vote397 views1 answer
Add new column in sql with foreign key
SQL
0 vote344 views1 answer
Get records in sql according to month name and count
SQL
1 vote379 views1 answer
Sql server insert into temp table
SQL