28,391
社区成员
发帖
与我相关
我的任务
分享这样写哪里错了!!
select top 12 * from cgzp where class2='酷绚' and not in(select top 5 * from cgzp where class2='酷绚' order by id desc) order by id desc
...全文
请发表友善的回复…
发表回复
gongyu 2006-02-14
- 打赏
- 举报
谢谢,不过通过实践应该这么写:
select top 12 * from cgzp where class2='酷绚' and id not in (select top 5 id from cgzp where class2='酷绚' order by id desc) order by id desc
不过还是要多谢你们!!
select top 12 * from cgzp where class2='酷绚' and id not in (select top 5 id from cgzp where class2='酷绚' order by id desc) order by id desc
不过还是要多谢你们!!
KimSoft 2006-02-14
- 打赏
- 举报
'错了，看下面
select top 12 * from cgzp where class2='酷绚' and id not in(select top 5 id from cgzp where class2='酷绚') order by id desc
select top 12 * from cgzp where class2='酷绚' and id not in(select top 5 id from cgzp where class2='酷绚') order by id desc
KimSoft 2006-02-14
- 打赏
- 举报
select top 12 * from cgzp where class2='酷绚' and not id in(select top 5 id from cgzp where class2='酷绚') order by id desc
flying0108 2006-02-14
- 打赏
- 举报
select top 12 * from cgzp where class2='酷绚' order by id desc
.....
rs.move(5)
.....
.....
rs.move(5)
.....
