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报错的
id name
-----------
1 xxx
2 111
3 xxx
4 333
要求查出来的结果为:
name
-----------
333
xxx
111
怎么实现??请教高手 select disticnt id,name
from 表 order by id desc我本来是这样写的 但这写法是在access报错的
from 表 group by name 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
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 id,name
from 表 order by id desc
)