sql 查询问题

SQL code:
表A：

id name date
1 aa 2009-12-23
2 aa
3 aa 2009-12-25
4 bb 2009-12-23
5 bb 2009-12-28
6 cc 2009-12-30

我想查询出来的结果：

id name date
3 aa 2009-12-25
5 bb 2009-12-28
6 cc 2009-12-30


就是当name一样的时候，查询出id最大的一个

---

SQL code:
SELECT * from TB T WHERE ID=(SELECT MAX(ID) from TB WHERE NAME=T.NAME)

---

SQL code:
select *
from A t
where not exists (select 1
from A where name=t.name and id>t.id)

---

SQL code:
SELECT * from TB T WHERE NOT EXISTS (SELECT 1 from TB WHERE NAME=T.NAME AND ID<T.ID)

---

SQL code:
select t1.*
from A t1 inner join (
select max(id) from A group by name
) t2 on t1.id=t2.id


SQL code

---

Code highlighting produced by Actipro CodeH