在不同資料庫中查詢前10筆記錄的Select用法

1. ORACLE 

SELECT * FROM TABLE1 WHERE ROWNUM<=10

2. INFORMIX 

SELECT FIRST 10 * FROM TABLE1 

3. DB2 

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

或者

SELECT COLUMN FROM TABLE FETCH FIRST 10 ROWS ONLY 

4. SQL SERVER 

SELECT TOP 10 * FROM TABLE1 

5. SYBASE

SET ROWCOUNT 10  GO SELECT * FROM TABLE1 

6. MYSQL

SELECT * FROM TABLE1 LIMIT 10 

7. FOXPRO

SELECT * TOP 10 FROM TABLE ORDER BY COLUMN