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

0 vote162 views1 answer
Install postgresql 12 on debian 10
SQL
0 vote118 views1 answer
INSERT INTO table using OpenQuery
SQL
2 votes142 views2 answers
Calculate percentage in sql
SQL
1 vote123 views1 answer
Postgres first_value in gropby
SQL
0 vote191 views1 answer
Postgresql powershell query
SQL
1 vote125 views1 answer
Where database run
SQL
0 vote127 views1 answer
Criteria builder select subset of column
SQL
0 vote136 views1 answer
Trigger stock phpmyadmin output message
SQL
5 votes133 views2 answers
Sql server check port number
SQL
0 vote132 views1 answer
Datatables server side filter where clause
SQL