access 数据库 去除重复 并 以id倒序 的sql 写法

access 数据库 去除重复 并 以id倒序 的sql 写法

有一个表为：
id  name
-----------
1    xxx
2    111
3    xxx
4    333
要求查出来的结果为：
name
-----------
333
xxx
111
怎么实现？？请教高手

select disticnt id,name
from 表 order by id desc

我本来是这样写的 但这写法是在access报错的

---

select name
from 表 group by name order by id desc

---

你这样写的也不对啊

---

SQL code:
SELECT * from TB t where not exists(select 1 from TB where t.name=name And t.id<id) order by id desc

---

这个应该可以
select * from tb1 where [id] in
(
SELECT max([id])  from tb1 group by [name]
)
order by [id] desc


http://www.mybuffet.cn

---

SELECT d1.[num1], d1.[num2]
from t as d1  where d1.[num1] in (select max(d2.num1) from t as d2 where d2.num2 = d1.num2)
order by d1.num1 desc

---

select disticnt id,name
(
select  id,name
from 表 order by id desc
)