如何计算同一字段里相同值的值?

Question

比如我一表里的数据如下:卡编号         价格
88888801        2
88888802       2.5~~~~~~~~~~~~~~|
88888802        3               |
88888802        2               |→想合计出这一段的价格 
88888802       5.5              |
88888802       10 ______________|
88888805       11
88888807       20

Answer 1

select Sum(价格) from 表 Where 卡编号 = 88888802

Answer 2

select Sum(价格), 卡编号  from 表 Where 卡编号 = 88888802 GROUP BY 卡编号

Answer 3

select distinct 卡編號 , (select sum(價格)from 表 b where b.卡編號 = a.卡編號) 
from 表 a