oracle统计查语法,oracle统计查询 sql语句应当怎么写

select substrb(create_time,1,4) "年份",

sum(decode(substrb(create_time,6,2),'01',commission,0)) "1月",

sum(decode(substrb(create_time,6,2),'02',commission,0)) "2月",

sum(decode(substrb(create_time,6,2),'03',commission,0)) "3月",

sum(decode(substrb(create_time,6,2),'04',commission,0)) "4月",

sum(decode(substrb(create_time,6,2),'05',commission,0)) "5月",

sum(decode(substrb(create_time,6,2),'06',commission,0)) "6月",

sum(decode(substrb(create_time,6,2),'07',commission,0)) "7月",

sum(decode(substrb(create_time,6,2),'08',commission,0)) "8月",

sum(decode(substrb(create_time,6,2),'09',commission,0)) "9月",

sum(decode(substrb(create_time,6,2),'10',commission,0)) "10月",

sum(decode(substrb(create_time,6,2),'11',commission,0)) "11月",

sum(decode(substrb(create_time,6,2),'12',commission,0)) "12月"

from test

group by substrb(create_time,1,4)

此语句是按create_time字段是字符型给出的，如果你的表中此字段是日期型，则进行一下转化

取消

评论