34,590
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
xiao_deng 2006-11-14
- 打赏
- 举报
top 了两次
jordonkobe 2006-11-14
- 打赏
- 举报
select * from tablename a
where (select count(*) from tablename where 聚集索引列<=a.聚集索引列) between 4 and 5
where (select count(*) from tablename where 聚集索引列<=a.聚集索引列) between 4 and 5
xxsoft 2006-11-14
- 打赏
- 举报
很郁闷的问题。。算了，N个TOP
子乔 2006-11-14
- 打赏
- 举报
用触发器应该可以吧
pengda1i 2006-11-14
- 打赏
- 举报
如果有聚集索引，而且聚集索引唯一
select * from tablename a
where (select count(*) from tablename where 聚集索引列<=a.聚集索引列) between 4 and 5
select * from tablename a
where (select count(*) from tablename where 聚集索引列<=a.聚集索引列) between 4 and 5
冷箫轻笛 2006-11-14
- 打赏
- 举报
不会别的方法了
