Adding selects

Question

Adding selects

paeast

SSC Eights!

Points: 908
More actions
August 18, 2003 at 7:01 am

#101629

I have a table with three columns, Item_no, Date, Qty.
what I want to do is, select on this table but if there is for example 3 records with the same Item_no and Date, I would like it to add the qty up for these, and just give me one record back with the combined total. There are 100 of different records in the table but only 10 percent have duplicate item_no and Date and different Qty.
IF anyone can help I will be glad to give more info
Thanks in advance
Paul East

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

Hi Paul,

quote:
I have a table with three columns, Item_no, Date, Qty.
what I want to do is, select on this table but if there is for example 3 records with the same Item_no and Date, I would like it to add the qty up for these, and just give me one record back with the combined total. There are 100 of different records in the table but only 10 percent have duplicate item_no and Date and different Qty.

do you want something like

SELECT Item_no, SUM(Qty) AS blabla

GROUP BY Item_No ?

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

NPeeters SSChampion Points: 12536 More actions · Answer 2

And add the date to that solution to yield



SELECT item_no, date, sum(qty)

FROM table

GROUP BY item_no, date

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

quote:
And add the date to that solution to yield

SELECT item_no, date, sum(qty)
FROM table
GROUP BY item_no, date

err, yes!

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]