-- 方法1
-- 方法2
select a.* from table1 a where not exists(select 1 from table1 b where b.name=a.name and b.gdtime>a.gdtime)
-- 方法2
select a.* from table1 a inner join (select name, max(gdtime) 'maxgdtime' from table1 group by name) b on a.name=b.name and a.gdtime=b.maxgdtime
莹莹
莹莹 已转藏