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

1 vote322 views3 answers
Java.sql.sqlexception: access denied for user
SQL
0 vote307 views1 answer
Oracle get running queries
SQL
0 vote334 views2 answers
While mysql
SQL
0 vote346 views1 answer
MySQL update with subquery
SQL
1 vote331 views2 answers
Mysql trim spaces
SQL
4 votes331 views4 answers
Start mysql
SQL
0 vote341 views2 answers
Create-toys-table-with-toy_name-column
SQL
0 vote336 views1 answer
Insert ip address in mysql
SQL
0 vote312 views1 answer
Sqlplus change user
SQL
0 vote331 views1 answer
Check if a column is a primary key in sql server
SQL