数据库查询前几笔资料的语法

 

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