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 vote217 views1 answer
How to combine rows in sql server procedure
SQL
7 votes192 views3 answers
Postgre describe table
SQL
0 vote231 views2 answers
What is the default password for sql server sa
SQL
0 vote206 views1 answer
How to write if case in select query in select statement
SQL
0 vote219 views1 answer
Oracle winter time change
SQL
1 vote199 views2 answers
Begin transaction in sql
SQL
1 vote214 views1 answer
Sql server get users
SQL
0 vote197 views1 answer
Sql include rows with 0 values
SQL
10 votes259 views6 answers
Mysql set root password
SQL
1 vote269 views2 answers
Mysql SELECT
SQL