SQL Help

[DeathFox]

---

Unsaon pag.gama ani?



Item
Quantity


Product A
30


Product B
10


Product A
15



To



Item
Quantity


Product A
45


Product B
10

[cold_fusion]

select Item, Sum(Quantity) AS Quantity from table_name group by 1 order by 1

[dlanyer77]

row groupings, groups sorting and using function SUM rana bro.

[torade]

For more details, search google for Group by or look for the help on SQL Server Books Online usually it is included when you install MS SQL, go to Index tab and type Group by. It has a well documented details on how to use Group by.