ÇóÒ»ÌõsqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

Á½¸ö±íA,BÁ¬±í²éѯ£¬ÆäÖÐAÓÐid,name×Ö¶Î,BÓÐaid,cid×ֶΣ¬A.idºÍB.aidÊǹØÁªµÄ£¬B.cidÓкܶàÖظ´£¬ÇëÎÊÔõÑùÓÃÒ»¾ä»°ËÑË÷³öA.id,A.name,B.cidÁ¬±í½á¹û£¬ÆäÖи÷×ֶζ¼²»ÄÜÓÐÖظ´

---

ÊÇÕûÌõ¼Ç¼²»ÄÜÖظ´»¹ÊÇÿ¸ö×ֶζ¼²»ÄÜÖظ´£¿
Èç¹ûÓÐÖظ´ÒªÔõôȡ£¿

---

SQL code:
select distinct A.id,A.name,B.cid
from A,B where A.id=b.aid

---

SQL code:
select a.id,
a.name,
b.cid
from ta a ,tb b
where a.id=b.aid
and b.aid=(select max(aid)
from tb
where cid=b.cid)

---

ÒýÓÃ

SQL code
select distinct A.id,A.name,B.cid
from A,B where A.id=b.aid

À´µÄÖ±½ÓЩ...

---

²»ºÃÒâ˼˵´íÁË£¬²»ÊÇÿ¸ö×ֶζ¼²»Öظ´£¬ÊÇA±íµÄ×ֶβ»Öظ´£¬Èç¹ûB.cidÖظ´Ëæ±ãÈ¡Ò»Ìõ¾ÍÐÐ

xys_777ºÍwufeng4552µÄA±í¶¼ÓÐÖظ´

ÔÙ²¹³äһϣ¬BÖÐÒ»¸öÏàͬaid¿ÉÄܶÔÓ¦ºÜ¶à¸ö²»Í¬µÄcid£¬Í¬ÑùÒ»¸öÏàͬµÄcid¿ÉÄܶÔÓ¦²»Í¬µÄaid

---

×Ô¼º¶¥£¬´ó¼Ò°ïæ

---

SQL code:

with t as
(
select sn=ROW_NUMBER() over(partition by t1.aid order by t1.aid),* from (select a.aid, a.contents, c.cid from table1 a join table2 b on a.aid=c.bid) t1
)

select * from t where