7,714
社区成员
发帖
与我相关
我的任务
分享
...全文
请发表友善的回复…
发表回复
maoyesky 2003-12-07
- 打赏
- 举报
select * from (select top (m-n) * from (select top m * from table order by id) order by id desc) order by id
dgm8 2003-12-07
- 打赏
- 举报
有没有更简单的？？？
shanxing 2003-12-05
- 打赏
- 举报
学习
KenWin 2003-12-05
- 打赏
- 举报
呵呵！ changechange(改了又改) 指的那里分析得比较全啦！
changechange 2003-12-04
- 打赏
- 举报
http://access911.net/index.asp?board=4&recordid=72FAB41E14DC
enemyxu 2003-12-04
- 打赏
- 举报
哦，理解错误,sorry!
dgm8 2003-12-04
- 打赏
- 举报
to: enemyxu(fenxu) id是编号，中间可能有删除，
我还不如这样：（n>m)
select top (n-m) * from table where id not in (select top m * from table order by id) order by id
我还不如这样：（n>m)
select top (n-m) * from table where id not in (select top m * from table order by id) order by id
enemyxu 2003-12-04
- 打赏
- 举报
为什么no?
dgm8 2003-12-04
- 打赏
- 举报
to: enemyxu(fenxu) no!
enemyxu 2003-12-04
- 打赏
- 举报
SELECT *
FROM table WHERE ((ID>n) and (ID<m));
FROM table WHERE ((ID>n) and (ID<m));
