select * from(
select top 3 *
from ta
where isad = 0 order by id desc ) a
union all
select * from(
select top 1 *
from ta
where isad = 1 order by id desc) b
order by isad ,id desc
select top 3 *
from ta
where isad = 0 order by id desc ) a
union all
select * from(
select top 1 *
from ta
where isad = 1 order by id desc) b
order by isad ,id desc
不过再问一下
假如数据库里IsAD=1的没有
我就要再提取1条IsAD=0的但是同时IsSelected=1的补充,构造满4条记录怎么做呢