how to add columns data in sql server?

Question

in sql server 2008, i have two columns productu_code,quantity how to add quantity when product is same

      ______________________
      |productcode|quantity|
      ----------------------
      |FH5004     |  8     |
      |FH5016     |  4     |
      |FH5029     |  2     |
      |FH5004     |  6     |
      |FH5016     |  2     |
      |____________________|

  can you help me, thank you.

Martin Smith · Accepted Answer · 2011-09-20 09:24:42Z

2

SELECT productcode, 
       sum(quantity) as total_quantity
FROM YourTable
GROUP BY productcode

answered Sep 20, 2011 at 9:24

Martin Smith

457k97 gold badges777 silver badges887 bronze badges

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

Comments

AndrewC · Accepted Answer · 2011-09-20 09:25:24Z

1

SELECT SUM(Quantity) FROM table_name GROUP BY ProductCode

Is that what you're after?

answered Sep 20, 2011 at 9:25

AndrewC

6,73013 gold badges45 silver badges71 bronze badges

Comments

Saket · Accepted Answer · 2011-09-20 09:25:53Z

1

You can use this SQL:

SELECT productcode, SUM(quantity) as total_quantity
FROM Table t1
GROUP BY productcode

answered Sep 20, 2011 at 9:25

Saket

46.3k13 gold badges65 silver badges80 bronze badges

Collectives™ on Stack Overflow

how to add columns data in sql server?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related