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
 
Jimbo99999Asked:
Who is Participating?
 
TechTiger007Connect With a Mentor Commented:
That is the correct way :)
0
 
Jimbo99999Author Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.