22,209
社区成员
发帖
与我相关
我的任务
分享
select top 10 主键ID from
(select b.主键ID,b.信息ID from 信息表 as a right JOIN
子信息表 as b on a.信息ID=b.信息ID where
a.ischeck=0 and a.cityid=1) as temp
where 主键ID not in
(select top 10 主键ID from
(select b.主键ID,b.信息ID from 信息表 as a right JOIN
子信息表 as b on a.信息ID=b.信息ID where
a.ischeck=0 and a.cityid=1) as temp1
order by 主键ID desc)
order by 主键ID desc