Implement select Top N in Oracle

How to Use select top in different databases:

 

1. Oracle Database (Oracle does not support the select top statement. Therefore, the combination of order by and rownum is often used in Oracle to query the select Top N)

 

SELECT * FROM TABLE1 WHERE ROWNUM<=N

 

2. infomix Database

 

SELECT FIRST N * FROM TABLE1

 

3. DB2 database

 

SELECT * ROW_NUMBER() OVER(ORDER BY COL1 DESC) AS ROWNUM WHERE ROWNUM<=N

 

Or

 

SELECT COLUMN FROM TABLE FETCH FIRST N ROWS ONLY

 

 

4. SQL Server database

 

SELECT TOP N * FROM TABLE1

 

5. Sybase Database

 

SET ROWCOUNT N GO SELECT * FROM TABLE1

 

 

6. MySQL database

 

SELECT * FROM TABLE1 LIMIT N

 

 

7. FoxPro Database

 

SELECT * TOP N FROM TABLE ORDER BY COLUMN