ÇóÒ»¸öOracle²écountµÄÓï¾ä

ÓÐÈýÕűí
tableA ×ֶΠaid,aname
tableB ×ֶΠaid,bid
tableC ×ֶΠcid,cname,aid

ÎÒÒª²é³ö tableA µÄaid,aname ºÍtableBÖÐaidÏà¶ÔÓ¦µÄbid ºÍ tableCÖÐaidÏà¶ÔÓ¦µÄ×ÜÊý
ÎÒÔ­À´µÄ˼·ÊÇ
1¡¢select ta.aid,ta.aname,tb.bid from tableA ta,tableB b where ta.aid = tb.aid;
2¡¢±éÀúÉÏÃæ²é³öµÄList£¬Í¨¹ýaidÈ¥ select count(cid) from tableC where aid=.....

¿ÉÊÇÏÖÔÚµÚ1²½²éѯ£¬Êý¾ÝÁ¿ÓÖ4000¶àÌõ
Èç¹ûÔÚµÚ2²½È¥±éÀúµÄ»°£¬Òª²é4000¶à´Î

ºÄʱ1·Ö¶àÖÓ

ÓÐûÓÐÒ»ÌõSQLÓï¾äÄÜÂú×ãÎÒµÄÌõ¼þ£¿
¼±Ç󣡣¡

---

SQL code:
select a.aid,aname,bid,num from
(select a.aid,aname,bid from tableA a,tableB b where a.aid = b.aid) a,
(select aid,count(cid) num from tableC group by aid) b
where a.aid = b.aid;

---

select ta.aid,ta.aname,tb.bid,count(c.cid) over(partition by ta.aid)
from tableA ta,tableB b, tableC c
where ta.aid = tb.aid
and  ta.aid = c.aid(+);

---

ÒýÓÃ

select ta.aid,ta.aname,tb.bid,count(c.cid) over(partition by ta.aid)
from tableA ta,tableB b, tableC c
where ta.aid = tb.aid
and  ta.aid = c.aid(+);

UP

---

ÒýÓÃ

select ta.aid,ta.aname,tb.bid,count(c.cid) over(partition by ta.aid)
from tableA ta,tableB b, tableC c