ÇóÒ»ÌõSQLÓï¾ä

±í
ID PROVINCE CITY
1 ¹ã¶« ¹ãÖÝ
2 ¹ã¶« ÉîÛÚ
3 ºþ±± Î人

½á¹û£º
ID PROVINCE
1 ¹ã¶«
3 ºþ±±

---

SQL code:
select distinct PROVINCE from tb

---

SQL code:
select *
from tb t
where ID =(select max(ID ) from tb where PROVINCE=t.PROVINCE)

---

ÒýÓÃ

SQL codeselectdistinct PROVINCEfrom tb

ÐÖµÜÁ©

---

SQL code:
create table #TT1
(
ID int,
PROVINCE varchar(30),
CITY varchar(30)
)
insert into #TT1 select 1,'¹ã¶«','¹ãÖÝ'
insert into #TT1 select 2,'¹ã¶«','ÉîÛÚ'
insert into #TT1 select 3,'ºþ±±','Î人'

select min(ID) ID,PROVINCE from #TT1 group by PROVINCE
ID PROVINCE
----------- ------------------------------
1 ¹ã¶«
3 ºþ±±

(2 ÐÐÊÜÓ°Ïì)

---

ÒýÓÃ

SQL codeselectdistinct PROVINCEfrom tb

ûÓÐIDÄÇÒ»ÁÐѽ£¬

---

ʲôҪÇó£¿

ÄѵÀÊÇÑ¡ÔñcityÊÇprovinceµÄÊ¡»áµÄ¼Ç¼£¿

---

ÒýÓÃ

ÒýÓà 1 Â¥ ws_hgo µÄ»Ø¸´:SQL codeselectdistinct PROVINCEfrom tb
ÐÖµÜÁ©<