ÇóÒ»ORACLE Óï¾ä~~

ÏÖÔÚÓÐÒ»Õűí ÎÒÏë¸ù¾ÝÈÕÆÚ²é³ö¸ÄÌìÒ»¹²ÓжàÉÙÌõ¼Ç¼ Ò»¹²Ò»¸öÔ  ÎÒÏëÏÔʾµÄ·½Ê½ÊÇ 

2010-10-5  100

2010-10-6  200

...

ÕâÑù~

---

SQL code:

select _date,sum(amount) from table group by trunc(_date,'dd');

---

SQL code:

select to_char(ÈÕÆÚ,'yyyy-mm-dd'),sum(1)
from ±íÃû
where ÈÕÆÚ between to_date(trunc(sysdate,'mm'))
and add_months(to_date(trunc(sysdate,'mm')),1)-1/24/3600
group by to_char(ÈÕÆÚ,'yyyy-mm-dd'),£»

---

ÒýÓÃ

SQL codeselect to_char(ÈÕÆÚ,'yyyy-mm-dd'),sum(1)from ±íÃûwhere ÈÕÆÚbetween to_date(trunc(sysdate,'mm'))and add_months(to_date(trunc(sysdate,'mm')),1)-1/24/3600groupby to_char(ÈÕÆÚ,'yyyy-mm-dd'),£»

  up£¡

---

select to_char(ÈÕÆÚ,'yyyy-mm-dd'),sum(1)
  from ±íÃû
  where ÈÕÆÚ between to_date(trunc(sysdate,'mm'))
                and add_months(to_date(trunc(sysdate,'mm')),1)-1/24/3600
group by to_char(ÈÕÆÚ,'yyyy-mm-dd')£»

---

ÄÜ·ñ¼Ó¸öÅÅÐò£¿