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 vote200 views1 answer
Docker open terminal mysql server
SQL
0 vote175 views1 answer
Split a string with expression and get the last value of split sql
SQL
0 vote202 views1 answer
Get number of tables in database sql
SQL
-2 votes207 views1 answer
Group functions in sql
SQL
0 vote205 views1 answer
Sql check if column exists
SQL
0 vote213 views1 answer
Oracle query to find schema you are working on
SQL
1 vote222 views2 answers
Mysql add column tinyint default 0
SQL
1 vote205 views1 answer
Mysql show database size in mb
SQL
0 vote201 views1 answer
Implizite joins sql
SQL
0 vote231 views1 answer
How to fetch data from database in sql
SQL