现有一张统计表statistics,其中包含了数量字段success_count和日期字段RECORD_TIME(Date类型,精确到秒),我根据RECORD_TIME进行了group by的查询语句为:
SELECT SUM(S.SUCCESS_COUNT) TOTAL_COUNT,
TO_DATE(TO_CHAR(S.RECORD_TIME, 'yyyy/MM/dd'), 'yyyy/MM/dd') STATISTICS_DATE
FROM STATISTICS S
GROUP BY S.RECORD_TIME
ORDER BY S.RECORD_TIME;