在DB2下如何限制查詢的數目?

ddmmdd

能说详细一点吗？

neo2718

是返回记录的条数限制吗?

ddmmdd

select * from table1  fetch first n rows

minimini

用ROW_NUMBER() OVER()


SELECT T.*
FROM T,(SELECT ID,ROW_NUMBER() OVER (ORDER BY ID) AS NUM FROM T) AS T1
WHERE T.ID=T1.ID AND T1.NUM<N&#59;

--查前N行

superjj

select * from table1 fetch first n rows only
that is enough

color440

帮助太大了，我也正被这样的问题所困扰