sql help

[ShyamSunder]

bhayyas....naku sql peda ga radhu...ippudu ippude leaning...yavarina koncham help cheyara

 

Actual Data:

Barcode#   Name  Quantity

1                 ABCD      2

1                  ABCD      4

3                  xxxxx      3

3                   xxxxx    7

4                   ZZZZ     8

 

Required Output:

Barcode#   Name  Quantity

1                 ABCD      6

3                  xxxxx      10

4                   ZZZZ     8

 

[nene_nani]

Select Barcode#,name, sum(Quantity) as Qty

from table

group by Barcode#, name

order by Barcode#

[Aakupaccha_caradu]

[ShyamSunder]

12 minutes ago, nene_nani said:

Select Barcode#,name, sum(Quantity) as Qty

from table

group by Barcode#, name

order by Barcode#

thx bhayya...nenus ame chesa but grp by qty kuda peta anduke raledhu mundhu

[Lakhan]

12 minutes ago, Aakupaccha_caradu said: