分析函数 SUM(QTY)OVER(PARTITION BY TO_CHAR(时间,'YYYY') ORDER BY 时间), SUM(QTY)OVER(PARTITION BY TO_CHAR(时间,'YYYYMM') ORDER BY 时间), SUM(QTY)OVER(PARTITION BY TO_CHAR(时间,'YYYYMMDD') ORDER BY 时间),
select sum(生产数量) 生产数量,to_char(生产时间,'yyyymmdd') 日 from test group by to_char(生产时间,'yyyymmdd') select sum(生产数量) 生产数量,to_char(生产时间,'yyyymm') 月 from test group by to_char(生产时间,'yyyymm')select sum(生产数量) 生产数量,to_char(生产时间,'yyyy') 年 from test group by to_char(生产时间,'yyyy')
SUM(QTY)OVER(PARTITION BY TO_CHAR(时间,'YYYY') ORDER BY 时间),
SUM(QTY)OVER(PARTITION BY TO_CHAR(时间,'YYYYMM') ORDER BY 时间),
SUM(QTY)OVER(PARTITION BY TO_CHAR(时间,'YYYYMMDD') ORDER BY 时间),
from test
group by to_char(生产时间,'yyyymmdd')
select sum(生产数量) 生产数量,to_char(生产时间,'yyyymm') 月
from test
group by to_char(生产时间,'yyyymm')select sum(生产数量) 生产数量,to_char(生产时间,'yyyy') 年
from test
group by to_char(生产时间,'yyyy')