select * from tb t where not exists(select 1 from tb where name=t.name and time>t.time)
select * from tb t where time=(select max(time) from tb where name=t.name) select a.* from tb a inner join (select name,max(name) from tb group by name) as b on a.name=b.name
select a.* from tb a inner join (select name, max([time]) 'maxtime' from tb group by name) b on a.name=b.name and a.[time]=b.maxtime
select name,max(time) time from tb group by name 不行吗?
select a.* from tb a inner join (select name,max(name) from tb group by name) as b on
a.name=b.name
select a.*
from tb a
inner join
(select name,
max([time]) 'maxtime'
from tb
group by name) b on a.name=b.name and a.[time]=b.maxtime
不行吗?