sqlÎÊÌâ

ÏÂÃæÕâ¶ÎÓï¾äΪʲô¼ÓÉÏKINMU_GOKEI.TY_JIKAGAI¾Í±¨00797µÄ´í£¿£¿Çë´óÏÀÖ¸µã¡£À˸çÔÚô£¿

SELECT KINMU_GOKEI.TY_JIKAGAI
,TO_CHAR(Count(KINMU_DAIKYU.NENGETSU),'99.9')
from KINMU_MONTHLY
LEFT JOIN KINMU_GOKEI ON KINMU_GOKEI.IDCODE='861000' AND KINMU_GOKEI.KIGYO_CODE='1030' AND KINMU_GOKEI.NENGETSU=KINMU_MONTHLY.NENGETSU
LEFT JOIN KINMU_DAIKYU ON KINMU_DAIKYU.IDCODE='861000' AND KINMU_DAIKYU.KIGYO_CODE='1030' AND KINMU_DAIKYU.NENGETSU=KINMU_MONTHLY.NENGETSU
LEFT JOIN KINMU_DAITAI ON KINMU_DAITAI.IDCODE='861000' AND KINMU_DAITAI.KIGYO_CODE='1030' AND KINMU_DAITAI.NENGETSU=KINMU_MONTHLY.NENGETSU
WHERE  KINMU_MONTHLY.IDCODE='861000' AND KINMU_MONTHLY.KIGYO_CODE='1030'
GROUP BY KINMU_DAIKYU.NENGETSU ORDER BY KINMU_DAIKYU.NENGETSU DESC ;

---

KINMU_GOKEI.TY_JIKAGAI  ²»ÊÇGROUP BY ¸ñʽ°É

---

ʲôÊÇGROUP BY ¸ñʽ£¿£¿£¿

---

Äã×Ðϸ¿´¿´
SELECT KINMU_GOKEI.TY_JIKAGAI
,TO_CHAR(Count(KINMU_DAIKYU.NENGETSU),'99.9')
from KINMU_MONTHLY
GROUP BY KINMU_DAIKYU.NENGETSU ORDER BY KINMU_DAIKYU.NENGETSU DESC ;

---

ÍÂѪÖÐ.....´ó¸ç²»ÒªÂô¹Ø×ÓÁË£¡£¡£¡£¡£¡

---

ʵÑéÊý¾Ý

SQL> select *  from student;
        ID    CLASSNO NAME
---------- ---------- ------------------
        1