一个select的问题 分都给完了~~~~

[jimmyhoum]

ID Name Scroe Time
001 A 90 2006-1-1
002 A 80 2006-10-1
003 B 95 2006-11-10
004 C 50 2006-12-1
005 B 40 2006-4-3
006 A 60 2006-5-7

要求用一句sql语句查询，结果：
ID Name Scroe Time
002 A 80 2006-10-1
003 B 95 2006-11-10
004 C 50 2006-12-1

结果Name必须是唯一的并且Time字段取最近的，切每个不同的Name都必须出现

[冷箫轻笛]

select * from tablename t1
where not exists (select 1 from tablename where name = t1.name and time > t1.time)

[rea1gz]

select * from tablename a
where time=(select max(time) from table where a.Name=Name)

[xieyong1985]

select *from grade
where Times in(select max(Times)from grade group by name)
order by name