如何在SQL中使用SUM [英] How to work with SUM in SQL

问题描述

Hi Geeks

Hi Geeks

Combo  Sizes   Ratio
  1     56       1
  1     62       2
  1     68       2
  1     74       1 
  1     80       1
  2     62       1
  2     68       2
  2     74       2
  2     80       1

我有一个复选框，在UI中显示1& 2。当我选择1和2时，我应该得到这样的结果

I've a checkbox which shows 1&2 in UI. When I select both 1 and 2, I should get result like this

Sizes   Ratio
 56       1
 62       3
 68       4
 74       4
 80       2

应根据尺寸添加比率。我坚持逻辑。任何人都可以帮我解决这个问题吗？

which should add the ratio according to the sizes. I stuck up with logic. Can anyone help me with this logic?

推荐答案

试试：

Try:

SELECT Sizes, SUM(Ratio) AS Ratio 
FROM MyTable
GROUP BY Sizes

这篇关于如何在SQL中使用SUM的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！