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 vote224 views1 answer
Varchar plsql
SQL
6 votes163 views1 answer
Phpmyadmin reset root password
SQL
2 votes162 views1 answer
Sql alchemy or
SQL
5 votes204 views1 answer
Get column name sql server
SQL
0 vote167 views1 answer
Como saber si tengo mysql instalado
SQL
0 vote132 views2 answers
Postgresql could not start server mac
SQL
4 votes181 views6 answers
List all tables in postgres
SQL
0 vote183 views1 answer
Oracle sql number to varchar2
SQL
12 votes182 views5 answers
Sql primary key
SQL
6 votes172 views3 answers
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.term.year' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL