数据表字段如何求和

数据表字段怎么求和？
数据表 qb_shop_content 里有N篇文章，fid=1 - N; 篇 里的jinbi字段的和，select怎么写？

如 fid=1 uid=1 jinbi=5
 
  fid=2 uid=1 jinbi=10

  fid=3 uid=1 jinbi=3

  fid=N uid=1 jinbi=N


jinbi=(fid=1的金币数)+(fid=2的金币数)+（fid=3的金币数）+(fid=N的金币数)

 

[解决办法]
SELECT sum(jinbi),uid AS fennum FROM qb_shop_content
group by uid
[解决办法]

SQL code

select  uid,sum(jinbi)from qb_shop_content group by uid
[解决办法]
select sum(jinbi) from qb_shop_content
[解决办法]
SQL code
select sum(jinbi) as jinbi from qb_shop_contentwhere uid=1