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
)