编程论坛 → ASP技术论坛

sql语句实现功能选出所有的条目去掉前5个

zmhdxy 发布于 2008-03-30 13:10， 823 次点击

下面的是选出前5个
select top 5 * from music where music_begin=0 order by music_id desc

5 回复

dhdhzzw2008-03-30 13:24

这是n到m个，看能不能给你启发。。。。
select top m * from tablename where id not in (select top n id from tablename)

zmhdxy2008-03-30 22:18

你就不能直接说啊让我想想吧

zmhdxy2008-03-31 13:08

谢谢提示搞定了
strSQL = "select * from music where music_id not in (select top 5 music_id from music where music_begin=0 order by music_id desc) and music_begin=0 order by music_id desc"

lefan2008-03-31 17:41

strSQL = "select * from music where music_id not in (select top 5 music_id from music order by music_id desc) order by music_id desc"
这样就可以了吧？

zmhdxy2008-04-01 15:41

当然可以啦和我的不是一样吗我只不过加了个条件

sql语句 实现功能 选出所有的条目 去掉前5个

sql语句实现功能选出所有的条目去掉前5个