34,588
社区成员
发帖
与我相关
我的任务
分享
select distinct a.name1 ,(select top 1 name2 from t_a as b where b.name1= a.name1) from t_a as a
select * from t_a a
where (select count(*) from t_a where name1=a.name1 and name2>a.name2)<1
select name1,min(name2) name2
from t_a
group by name1