从同一列获取infor并将其显示在多个列上

Question

我想找出每个性别的销售总和，并将其显示在单独的列中。因此，性别栏有M和F，而SalesAmount有这些性别的各种销售。我要找的是显示M的总销售额和F的总销售额在单独的列。你能帮我写一下sql代码吗？谢谢

​

​

Answer 1

用例：

  select  sum(case when Gender='M' then sales else 0 end) as M,
  sum(case when Gender='F' then sales else 0 end) as F from table

Answer 2

这会有帮助的，

 SELECT Name,Gender,sum(sales), sum(case when Gender='M' then sales else 0 end) as MaleSales,
      sum(case when Gender='F' then sales else 0 end) as FemaleSales 
      FROM table
     group by Name,Gender