需求如下:
一个表中有这样的结构
时间 a1 a2 a3
2008-10-09 1 2 1
2008-10-10 2 3 4
2008-11-12 3 4 5
2008-11-14 4 5 6
2008-12-14 5 6 7时间是datatime 类型的
要求实现对月份的 a1 a2 a3 数值进行统计如:
时间 totala1 totala2 totala3
2008-10 3 5 5
2008-11 7 9 11
2008-12 5 6 7请问这样的sql能写吗,小弟初入oracle 还请高手指点
一个表中有这样的结构
时间 a1 a2 a3
2008-10-09 1 2 1
2008-10-10 2 3 4
2008-11-12 3 4 5
2008-11-14 4 5 6
2008-12-14 5 6 7时间是datatime 类型的
要求实现对月份的 a1 a2 a3 数值进行统计如:
时间 totala1 totala2 totala3
2008-10 3 5 5
2008-11 7 9 11
2008-12 5 6 7请问这样的sql能写吗,小弟初入oracle 还请高手指点
to_char(时间,'YYYY-MM') as 时间,
sum(a1) as totala1,
sum(a2) as totala2,
sum(a3) as totala3
from tb
group by to_char(时间,'YYYY-MM')
SUM(a1) AS totala1,
SUM(a2) AS totala2,
SUM(a3) AS totala3
FROM test
GROUP BY TO_CHAR(SJ, 'YYYY-MM')
SUM(a1) AS totala1,
SUM(a2) AS totala2,
SUM(a3) AS totala3
FROM test
GROUP BY TO_CHAR(SJ, 'YYYY-MM')