22,209
社区成员
发帖
与我相关
我的任务
分享
select * from tb t
where id=(select top 1 id from tb where bigclassid=t.bigclassid)
order by itime
select * from [Table] a
where not exists(select 1 from [Table] where bigclassid=a.bigclassid and itime>a.itime)
order by itime