Sql limit results returned

-- 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 vote232 views3 answers
Alter schema sql server
SQL
0 vote191 views1 answer
Trigger value from maltiple table to single table mysql
SQL
0 vote163 views1 answer
Mysql insert with foreign key
SQL
0 vote209 views1 answer
Pass array parameter to stored procedure c#
SQL
0 vote196 views4 answers
Restart MySQL
SQL
1 vote204 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
4 votes239 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
4 votes228 views1 answer
Describe table mysql
SQL
0 vote211 views1 answer
Shows all databases created by user in ms sql
SQL
0 vote203 views1 answer
Create bdd mysql
SQL