17,086
社区成员
发帖
与我相关
我的任务
分享
select name, stat. dat
from gdgdgd g1
where exists (select name, max(dat) from gdgdgd g2 where g1.name=g2.name
group by name
having max(dat)=g1.dat )
select name, stat. dat
from gdgdgd g1
where exists (select name, max(dat) from gdgdgd g2 where g1.name=g2.name
having max(dat)=g1.dat )