不清楚楼主的意思。 1:select sms,count(feeid),sum(price) from 表 group by sms 2: select feeid,sum(price) from 表 group by feeid
select sms,count(feeid) 数量,sum(price) 总和 from 表 group by sms
select sms ,sum(case when feeid='frt' then 1 else 0 end) FrtCount ,sum(case when feeid='frt' then price else 0 end )FrtTotal ,sum(case when feeid='love' then 1 else 0 end) LoveCount ,sum(case when feeid='love' then price else 0 end) LovePrice from 表 group by smsor: select sms,feeid,count(*),sum(price) from 表 group by sms,feeid
select sms,count(feeid),sum(price) from yourtable group by sms,feeid
1:select sms,count(feeid),sum(price) from 表 group by sms
2: select feeid,sum(price) from 表 group by feeid
,sum(case when feeid='frt' then 1 else 0 end) FrtCount
,sum(case when feeid='frt' then price else 0 end )FrtTotal
,sum(case when feeid='love' then 1 else 0 end) LoveCount
,sum(case when feeid='love' then price else 0 end) LovePrice
from 表 group by smsor:
select sms,feeid,count(*),sum(price) from 表 group by sms,feeid