4816
社区成员
select name as '字母',
max(case when date='2013-01-01' then amount else 0 end) as '初期金额',
sum(case when date>'2013-01-01' then amount else 0 end) as '本期金额',
sum(amount) as '累计金额'
from tab group by name
select name as '字母',
sum(case when date<'2013-01-01' then amount else 0 end) as '初期金额',
sum(case when date>='2013-01-01' AND date<='2013-01-02' then amount else 0 end) as '本期金额',
sum(case when date<'2013-01-02' then amount else 0 end) as '累计金额'
from tab group by NAME
select name as '字母',
sum(case when date='2013-01-01' then amount else 0 end) as '初期金额',
sum(case when date>'2013-01-01' AND date<='2013-01-02' then amount else 0 end) as '本期金额',
sum(case when date<'2013-01-02' then amount else 0 end) as '累计金额'
from tab group by NAME
其实你自己改改也是可以的