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

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

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

谢谢提示 搞定了
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"

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"
这样就可以了吧？

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