How to add specific values in a column (SQL)

Question

the table is like this

Product_Group      value
a                   100
a                    50
b                    50
b                    50
b                   100
c                   200

and I need to create a new column and at the same time take out the redundancy in Product_Group, so the result should be

Product_group      Sum
a                   150
b                   200
c                   200

Cheers!

do you actually need to remove the records permanently and update permanently or just show the results in a select? also what version of sql are you using? (sql-server, oracle, mysql?) — Jeremy C.
– Jeremy C., Commented Jun 24, 2015 at 13:57

HaveNoDisplayName · Accepted Answer · 2015-06-24 13:58:58Z

2

You can use Group BY Clause. However, this is not a good idea to use reseverd keyword SUM as a column name, but if you want to wrap in bracekts.

SELECT Product_group, SUM(Value) as [SUM]
FROM tablename
GROUP BY Product_group

edited Jun 24, 2015 at 13:58

answered Jun 24, 2015 at 13:43

HaveNoDisplayName

8,537106 gold badges41 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

shubhamagiwal92 · Accepted Answer · 2015-06-24 13:46:40Z

0

Use the following Query in MySQL

 SELECT Product_group, SUM(Value) "SUM"
 FROM tablename
 GROUP BY Product_group

answered Jun 24, 2015 at 13:46

shubhamagiwal92

1,4324 gold badges26 silver badges50 bronze badges

Collectives™ on Stack Overflow

How to add specific values in a column (SQL)

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related