MySql 获取新列的每一行中的列的总和

Question

我有以下数据集:

market sale
fr       10
uk       10
fr       12
fr        3
uk        1

我想添加一个新列，我可以像这样在新列的每一行中显示销售额

market sale total sale 
fr       10         38 
uk       10         38 
us        3         38
fr        2         38
fr       12         38
uk        1         38

mu查询需要在Mysql中

谢谢

Answer 1

您请求选择的 id 设计错误，但如果您确实需要

您可以使用子选择计算列中的总和

SELECT  market, sale, (select sum(sale) as total from my_table) as  total
from my_table 

如果您只需要某个国家/地区，例如法国、英国，您可以

SELECT  market, sale, (select sum(sale) as total 
                           from my_table
                           where market in ('FR', 'UK')) as  total
from my_table 
here market in ('FR', 'UK')

或者你总是需要你能达到的总和

SELECT  market, sale, (select sum(sale) as total 
                           from my_table
                          ) as  total
from my_table 
here market in ('FR', UK')