＋设为首页 ＋添加到收藏夹
在同一个表中，比如
sms feeid price
1 frt 50
1 love 300
1 love 300
2 frt 50
2 love 300
怎样通过sms来查询统计feeid啊， 就是不同的feeid分别统计出来，feeid的数量和price的总和！
select sms,count(feeid) 数量,sum(price) 总和 from 表 group by sms
不清楚楼主的意思。
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 sms
or:
select sms,feeid,count(*),sum(price) from 表 group by sms,feeid
