SELECT 前幾筆資料 [DB2、ORACLE、MSSQL、INFORMIX]
--------------------------------------------------------------------------------
DB2 :
範例 : select * from db.tbdu01 order by userno fetch first 10 rows only
範例 : select * from db.tbdu01 order by userno fetch first 1 row only
ORACLE :
範例 : select * from db.tbdu01 order by userno where rownum < 11
MSSQL :
範例 : select top 10 * from db.tbdu01 order by userno
INFORMIX :
範例 : select first 10 * from db.tbdu01 order by userno
補充一下另外三個資料庫:
.SYBASE
SET ROWCOUNT 10
GO
SELECT * FROM TABLE1
. MYSQL
SELECT * FROM TABLE1 LIMIT 10
. FOXPRO
SELECT * TOP 10 FROM TABLE ORDER BY COLUMN