Çë½ÌÒ»ÌõSQLÓï¾ä

A±í
ÐÕÃû  ½èÇ®
A      10
A      20
B      20
B      30

B±í
ÐÕÃû  ´æ¿î
A    100
B    100

ÓÃSQLÓï¾äµÃ³öÒÔϽá¹û:
ÐÕÃû  ½èÇ®    Ê£ÓàÇ®
A      10      90
A      20      70
B      20      80
B      30      50


×îºÃÊÇÄܵóöÒÔϽá¹û:
ÐÕÃû  ½èÇ®    Ê£ÓàÇ®
A              100
A      10      90
A      20      70
B              100
B      20      80
B      30      50


×îºÃÊÇÓÃÒ»ÌõÓï¾ä¾Í¸ã¶¨, 3Q

---

Up!

---

SQL code:

select * from
(
select ÐÕÃû, null as ½èÇ®, ´æ¿î as Ê£ÓàÇ® from B
union all
select A.ÐÕÃû, A.½èÇ®, (B.´æ¿î-A.½èÇ®) as Ê£ÓàÇ® from
A left join B on
A.ÐÕÃû = B.ÐÕÃû
) t
order by ÐÕÃû, Ê£ÓàÇ® desc

---

SQL code

---

Code highlighting produced by Actipro CodeHighligh