Solved

VB.net Select SUM query

Posted on 2008-10-01
2
782 Views
Last Modified: 2008-10-03
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
Comment
Question by:Jimbo99999
2 Comments
 
LVL 13

Accepted Solution

by:
TechTiger007 earned 125 total points
Comment Utility
That is the correct way :)
0
 

Author Comment

by:Jimbo99999
Comment Utility
Thanks
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now