请教一个比较笨一点问题
请问DB2有没有LIMIT功能,是怎么实现的?
如果没有有没有高手可以告诉我怎么对DB2的记录数进行操作,也就是说从第N条取出第N+N条数据怎么做..
就象MYSQL一样LIMIT 0,10
问题点数：0、回复次数：3Top
1 楼dechon（Freedom）回复于 2003-08-06 22:14:40 得分 0
没有直接可以使用的，不过可以通过以下方法来解决：
select * from (select colname,rownumber( ) over (order by colname) as rn from table_name) as tmepory_table where rn between start_row and end_row;
Top
2 楼zhuqiang00（Alan）回复于 2003-08-07 14:42:50 得分 0
喔: 测试通过了
sql:
SELECT * FROM tablename WHERE primarykeyname NOT IN (SELECT primarykeyname FROM tablename ORDER BY primarykeyname DESC FETCH FIRST n ROW ONLY ) AND primarykeyname IN (SELECT primarykeyname FROM tablename ORDER BY primarykeyname DESC FETCH FIRST m ROW ONLY)
其中小写单词需要你自己填写 我的样例:
select * from zhuqiangtest where toid not in (select toid from zhuqiangtest order by toid desc fetch first 2 row only ) and toid in (select toid from zhuqiangtest order by toid desc fetch first 4 row only) 测试了通过
这句sql 只能在DB2中运行.
Top
3 楼m505（）回复于 2003-08-08 23:43:01 得分 0
应该是dechon的方法好...只需要排一次序...也不需要join(in clause)...Top
