关于汇总查询的有关问题

关于汇总查询的问题

SQL code

订单表ctoc_order日期字段ORDER_CREATE_TIME金额PRODUCT_AMOUNT查询2011-06-28到2012-05-28这段时间,每天交易总金额SELECT  ORDER_CREATE_TIME,sum(PRODUCT_AMOUNT)FROM ctoc_orderWHERE 1=1 and ORDER_SUBSTATUS in(0,1)and ORDER_CREATE_TIME between to_date('2011-06-28','yyyy-MM-dd') and to_date('2012-05-28','yyyy-MM-dd')group by ORDER_CREATE_TIME

这样查询后的结果,每天会有多条记录,没有达到汇总的目的
记录如下:

2011-06-2866.9
2011-06-2866.9
2011-06-2866.9
2011-06-2932.5
2011-07-06109
2011-07-06218
不知道SQL哪里错了...

[解决办法]

SQL code

订单表ctoc_order日期字段ORDER_CREATE_TIME金额PRODUCT_AMOUNT查询2011-06-28到2012-05-28这段时间,每天交易总金额SELECT  trunc(ORDER_CREATE_TIME),sum(PRODUCT_AMOUNT)FROM ctoc_orderWHERE 1=1 and ORDER_SUBSTATUS in(0,1)and ORDER_CREATE_TIME between to_date('2011-06-28','yyyy-MM-dd') and to_date('2012-05-28','yyyy-MM-dd')group by trunc(ORDER_CREATE_TIME)