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 vote268 views1 answer
Mysql connection with sqlalchecmy
SQL
0 vote324 views1 answer
New rails app with mysql
SQL
6 votes294 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
0 vote278 views1 answer
How to get table current identity value in sql server
SQL
0 vote268 views1 answer
Oracle create package body
SQL
0 vote294 views1 answer
Sql sum show 0 result
SQL
1 vote278 views1 answer
How to install mysql 8.0 windows service
SQL
0 vote333 views1 answer
Python dictionary to sql update
SQL
0 vote267 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
1 vote283 views2 answers
Change table name phpmyadmin
SQL