ASP中如何调用SQL中间数据

这个 直衫含接改sql 语句就能橘塌大实现了。圆竖。用子查询前三十 not in 子查询前三十
select top 30 * from musiclist where not in (select top 30 * from musiclist where IsGood=1 order by ID desc) and IsGood=1 order by ID desc

只把旁缺姿运绝sql="select top 30 * from musiclist where IsGood=1 order by ID desc"
改扮槐成: sql="select top 30 * from musiclist where IsGood=1 and id not in(select top 30 id from musiclist where IsGood=1 order by ID desc) order by ID desc"

select top 30 * from musiclist wher id in (select top 60 id from musiclist where IsGood=1 order by ID desc) order by id desc