• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 795
  • Last Modified:

VB.net Select SUM query

Good Day

Experts:

I am fairly certain what I want to accomplish but I am not certain how to set it up.  

I have a Table where several  records might have duplicate ItemName values.  When that happens, I want to add up all of the corresponding Qty values on the records.  Here is my effort at a query to do this:
select ItemName, Sum(Qty) as 'Summed Qty' from ITEM group by ItemName

Is this the best way to achieve my needed result?

Thanks,
jimbo99999
 
0
Jimbo99999
Asked:
Jimbo99999
1 Solution
 
TechTiger007Commented:
That is the correct way :)
0
 
Jimbo99999Author Commented:
Thanks
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now