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

0 vote387 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
0 vote377 views1 answer
How to login to mysql in homestead
SQL
1 vote367 views1 answer
Mysql size int
SQL
5 votes337 views1 answer
Sql first day of current year
SQL
0 vote361 views1 answer
Delete a record from a table sqlite3
SQL
5 votes351 views2 answers
Sql server check port number
SQL
0 vote375 views1 answer
Print boolean in plsql
SQL
0 vote315 views1 answer
Mysql find foreign key references
SQL
1 vote307 views1 answer
Postgres grant read only access to database
SQL
0 vote371 views1 answer
Sqlalchemy query sql compiled
SQL