Çë´ó¼Ò°ïһϣ¡OracleÁªºÏ²éѯµÄÎÊÌ⣡

µØÇøÃû³Æ µØÇø±àÂë
±±¾© 100001
ÉϺ£ 100002


µØÇø±àÂë ÈÕÆÚ ÌìÆø
100001 2009-1-1 Çç
100001 2008-2-1 Òõ
100002 2009-1-1 Çç


ʹʱàÂë µØÇø±àÂë ʹÊʱ¼ä
20091001 100001 2009-1-5
20092001 100002 2008-1-3


ÓÉÒÔÉÏÈý¸ö±í£¬Í¨¹ýÁªºÏ²éѯ»ñµÃÏÂÃæµÄͳ¼Æ±í£º
µØÇøÃû³Æ ÌìÆø ʱ¼ä ¸÷ÌìÆøÌìÊý ʹÊÊý ʹÊÂÊ£¨¸÷ÌìÆøÌìÊý/ʹÊÊý£©
±±¾© Çç 2008 10   5 2
±±¾© Çç 2009 5   1 5
±±¾© Òõ 2008 10   2 5
ÉϺ£ Çç 2008 10   2 5


ÔÚÏߵȸ÷λ³öÊÖ£¬Ð»Ð»£¡Çë¸ø³ö²éѯÓï¾ä£¡

---

²Î¿¼Ò»ÏÂÕâ¸ö
http://topic.csdn.net/u/20100119/12/87653ccc-6c4a-49b6-a0f8-e74e63822fd5.html?81317

ÄãÕâ¸öÉÔ΢¸´ÔÓһϣ¬²»¹ýÁ¬½Ó·½Ê½ÀàËÆ¡£

---

ºÃÏñ¶¼ÊÇ×÷Òµ°¡

---

ÒýÓÃ

²Î¿¼Ò»ÏÂÕâ¸ö
http://topic.csdn.net/u/20100119/12/87653ccc-6c4a-49b6-a0f8-e74e63822fd5.html?81317

ÄãÕâ¸öÉÔ΢¸´ÔÓһϣ¬²»¹ýÁ¬½Ó·½Ê½ÀàËÆ¡£

ÕâÀïµÄËƺõҲûÓнâ¾öµôÂÄܲ»ÄܸøÒ»¸ö²âÊԳɹ¦µÄÀý×Ó£¿

---

select  t1.µØÇø±àÂë £¬t1.µØÇøÃû³Æ,t2.ÌìÆø£¬t2.ÈÕÆÚ£¬count(distinct£¨t2.ÌìÆø£© £©count1, count(t3.ʹʱàÂë) count2
from table1  t1,table2 t2 ,table3 t3
where t1.µØÇø±àÂë =t2.µØÇø±àÂë(+)
  and t1.µØÇø±àÂë =t3.µØÇø±àÂë (+)
group by t1.µØÇø±àÂë £¬t1.µØÇøÃû³Æ,t2.ÌìÆø£¬t2.ÈÕÆÚ

ÀàËÆµÄ°É £¡£¡
{{-