troubleshooting Question

SQL .. SUM .. SUBSQL ?

Avatar of ginsonic
ginsonicFlag for Romania asked on
Microsoft SQL Server
2 Comments1 Solution461 ViewsLast Modified:
I have next table structure:

Name product   ...   buy/sale ... quantity

Cats ....   1 ( I buy ) ...  10
Dogs ...   1  ...              20
Birds ...   1 ...               14
Cats ....  -1 ( I sell )  ...   5
Dogs ...  -1...                  7
Cats ...    1 ...               12

I need a sql that will return me:

Cats ...  17
Dogs ... 13
Birds ... 14

Can help me with a SQL script, please ?
ASKER CERTIFIED SOLUTION
dduser

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros