SQL Query: Accumulate a column

jacom · Mar 27, 2001

Hallo, could somebody help me in this SQL-Problem?

My table contains the following columns:
Invoicenumber / Articlenumber / Quantity / Text

Records should be added in the column Quantity, when the Invoicenumbers are identical and Articlenumber are identical.

Example:
INVNO / ARTNO / QUAN / TEXT
4711 / 312 / 3 / Table
4711 / 434 / 6 / Chair
4711 / 312 / 2 / Table
4712 / 312 / 7 / Table

The result should be:
4711 / 312 / 5 / Table
4711 / 434 / 6 / Chair
4712 / 312 / 7 / Table

Thanks for help
Didi

Sep 25, 2001

accouding to your example,
i think the answer is

select invno,artno,sum(quan),text
from table_name
group by invno,artno,text

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

SQL Query: Accumulate a column

jacom

Computer

Guest

Similar threads

Part and Inventory Search

Sponsor