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 vote256 views2 answers
Sql query examples
SQL
0 vote373 views1 answer
How to show current database in mysql
SQL
0 vote266 views1 answer
How to count null values in sql
SQL
0 vote285 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
0 vote277 views1 answer
Renommer schema sql
SQL
1 vote300 views1 answer
Psql connections
SQL
0 vote295 views1 answer
Test the postgresql db connection
SQL
0 vote294 views1 answer
Sql server create constraint
SQL
9 votes286 views3 answers
Oracle undo usage by session
SQL
0 vote297 views1 answer
Sql count null values in all columns
SQL