select (select sum(fee) from table where flag='R1')
,(select sum(fee) from table where flag='R2')
,(select sum(fee) from table where flag='R3')
,(select sum(fee) from table where flag='R4')
,(select sum(fee) from table where flag='R5')
,(select sum(fee) from table where flag='R6')
,(select sum(fee) from table where flag='R2')
,(select sum(fee) from table where flag='R3')
,(select sum(fee) from table where flag='R4')
,(select sum(fee) from table where flag='R5')
,(select sum(fee) from table where flag='R6')
where flag>='R1' and flag<='R6'
group by flag或者来个狠的:select flag,sum(fee) as fee from tableName
where flag='R1' or flag='R2' or flag='R3' or flag='R4' or flag='R4' or flag='R6'
group by flag
sum(case flag='R1' then fee else 0 end) as R1,
sum(case flag='R2' then fee else 0 end) as R2,
sum(case flag='R3' then fee else 0 end) as R3,
sum(case flag='R4' then fee else 0 end) as R4,
sum(case flag='R5' then fee else 0 end) as R5,
sum(case flag='R6' then fee else 0 end) as R6
from tablename
group by flag
sum(case flag when 'r1' then fee else 0 end) as r1,
sum(case flag when 'r2' then fee else 0 end) as r2,
sum(case flag when 'r3' then fee else 0 end) as r3,
sum(case flag when 'r4' then fee else 0 end) as r4,
sum(case flag when 'r5' then fee else 0 end) as r5,
sum(case flag when 'r6' then fee else 0 end) as r6
from table
f.sR6 as R6 from
(select sum(fee) sR1 from table where flag='R1') a,
(select sum(fee) sR2 from table where flag='R2') b,
(select sum(fee) sR3 from table where flag='R3') c,
(select sum(fee) sR4 from table where flag='R4') d,
(select sum(fee) sR5 from table where flag='R5') e,
(select sum(fee) sR6 from table where flag='R6') f
select (select sum(fee) from table where flag='R1')
,(select sum(fee) from table where flag='R2')
,(select sum(fee) from table where flag='R3')
,(select sum(fee) from table where flag='R4')
,(select sum(fee) from table where flag='R5')
,(select sum(fee) from table where flag='R6')最简单!!用
select
sum(case flag='R1' then fee else 0 end) as R1,
sum(case flag='R2' then fee else 0 end) as R2,
sum(case flag='R3' then fee else 0 end) as R3,
sum(case flag='R4' then fee else 0 end) as R4,
sum(case flag='R5' then fee else 0 end) as R5,
sum(case flag='R6' then fee else 0 end) as R6
from tablename
group by flag也好!但只是一个表!
FROM TABLENAME
WHERE FLAG IN ('R1','R2',R3','R4','R5','R6')
GROUP BY FLAG
SELECT FLAG,SUM(FEE)
FROM TABLENAME
WHERE FLAG IN ('R1','R2','R3','R4','R5','R6')
GROUP BY FLAG
少了一个引号。
什么意思?^O^
sum(case flag='R1' then fee else 0 end) as R1,
sum(case flag='R2' then fee else 0 end) as R2,
sum(case flag='R3' then fee else 0 end) as R3,
sum(case flag='R4' then fee else 0 end) as R4,
sum(case flag='R5' then fee else 0 end) as R5,
sum(case flag='R6' then fee else 0 end) as R6
from tablename
group by flag
sum(case flag='R1' then fee else 0 end) as R1,
sum(case flag='R2' then fee else 0 end) as R2,
sum(case flag='R3' then fee else 0 end) as R3,
sum(case flag='R4' then fee else 0 end) as R4,
sum(case flag='R5' then fee else 0 end) as R5,
sum(case flag='R6' then fee else 0 end) as R6
from tablename
group by flag
另外,建议大家不要把前面的答案拷贝下来,还是自己的答案好一点。