34,590
社区成员
发帖
与我相关
我的任务
分享
--or:
select * from tbname a
where F3= (
select top 1 F3 from tbname
where F1=a.F1 and F2=a.F2 and F3<a.F3
order by F3
)
--or:
select * from tbname a
where F3= (
select min(F3) from tbname
where F1=a.F1 and F2=a.F2
)
select * from tbname a
where not exists (
select 1 from tbname
where F1=a.F1 and F2=a.F2 and F3<a.F3
)