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

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

引用：http://blog.csdn.net/pric/archive/2004/09/19/109608.aspx

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 GOSELECT * FROM TABLE1

6. MYSQL SELECT * FROM TABLE1 LIMIT 10

7. FOXPRO SELECT * TOP 10 FROM TABLE ORDER BY COLUMN

http://blog.blueshop.com.tw/jacksun/archive/2007/02/28/49737.aspx