这个sql语句该怎么写啊？

[duibudui]

table
---------------
(pk)ID NAME TIME
---------------
我需要得到的数据要符合这2个条件：
1. 没有重复的name
2. 如果table里有重复的name,取得TIME最大(时间最近)的纪录。

这该怎么写呢？

[愉快的登山者]

select * from table1 A
where [time] = (select max([time]) from table1 where [name] = A.name)

[friendliu]

select name, max([time]) as time from table
group by name

[happydreamer]

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

[happydreamer]

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

[dafu71]

select * from yourtable as ta where not exists(select 1 from yourtable where ta.[time]<[time] and ta.[name]=[name])

[sdhdy]

select * from tablename a where time in (select max(time) from tablename where name=a.name)

[pengdali]

select * from 你的表 tem where [TIME]=(select max([TIME]) from 你的表 where [name]=tem.[name])

[CrazyFor]

select * from tablename a where not exists (select 1 from tablename b where b.name=a.name and a.time<b.time)

[CrazyFor]

select * from tablename a where not exists (select 1 from tablename b where b.name=a.name and a.time<b.time)

[老宛]

select name,max(time) from table
group by name

[duibudui]

谢谢各位