ASP中如何调用SQL中间数据

2024-11-16 06:01:23

推荐回答（3个）

回答（1）：

这个直衫含接改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

回答（2）：

只把旁缺姿运绝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"

回答（3）：

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