[align=center][b]用SQL命令实现按月统计[/b][/align]
sales as '业务员',
sum(case when month(getdatetime)=1 then amount end) as '1月份总额',
sum(case when month(getdatetime)=2 then amount end) as '2月份总额',
sum(case when month(getdatetime)=3 then amount end) as '3月份总额',
sum(case when month(getdatetime)=4 then amount end) as '4月份总额',
sum(case when month(getdatetime)=5 then amount end) as '5月份总额',
sum(case when month(getdatetime)=6 then amount end) as '6月份总额',
sum(case when month(getdatetime)=7 then amount end) as '7月份总额',
sum(case when month(getdatetime)=8 then amount end) as '8月份总额',
sum(case when month(getdatetime)=9 then amount end) as '9月份总额',
sum(case when month(getdatetime)=10 then amount end) as '10月份总额',
sum(case when month(getdatetime)=11 then amount end) as '11月份总额',
sum(case when month(getdatetime)=12 then amount end) as '12月份总额'
from you_table group by sales
select extract(year from tf_date),extract(month from tf_date),sum(tf_sl)
from table
where ...
group by extract(year from tf_date),extract(month from tf_date)
sales as '业务员',
sum(case when month(getdatetime)=1 then amount end) as '1月份总额',
sum(case when month(getdatetime)=2 then amount end) as '2月份总额',
sum(case when month(getdatetime)=3 then amount end) as '3月份总额',
sum(case when month(getdatetime)=4 then amount end) as '4月份总额',
sum(case when month(getdatetime)=5 then amount end) as '5月份总额',
sum(case when month(getdatetime)=6 then amount end) as '6月份总额',
sum(case when month(getdatetime)=7 then amount end) as '7月份总额',
sum(case when month(getdatetime)=8 then amount end) as '8月份总额',
sum(case when month(getdatetime)=9 then amount end) as '9月份总额',
sum(case when month(getdatetime)=10 then amount end) as '10月份总额',
sum(case when month(getdatetime)=11 then amount end) as '11月份总额',
sum(case when month(getdatetime)=12 then amount end) as '12月份总额'
from you_table group by sales
select extract(year from tf_date),extract(month from tf_date),sum(tf_sl)
from table
where ...
group by extract(year from tf_date),extract(month from tf_date)