select _date,sum(amount) from table group by trunc(_date,'dd');
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'),;
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');
select _date,sum(amount) from table group by trunc(_date,'dd');
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'),;
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');