Re: SQL query

Elena wrote:

> Hi,
> I have a table1 like this:
>
> DATE PACKING LIST ITEM CODE QTY LOT DESCRIPTI
> 24-FEB-03 211011290OP 21140320011 7 23408 ...
> 24-FEB-03 211011290OP 21140320011 2 23410 ...
> 24-FEB-03 211011290OP 26340791011 5 23408 ...
> 24-FEB-03 211011290OP 26340791011 2 23408 ...
> 27-FEB-03 21108433 26247383011 6 29510
> ...
> 27-FEB-03 57840320058 20143344011 3 29510
> ...
> 27-FEB-03 57840320058 20143344011 10 29510
>
> I would like to have the following OUTPUT from a query which I'm not able to
> write.
>
> DATE PACKING LIST ITEM CODE QTY LOT
> 24-FEB-03 211011290OP 21140320011 7 23408
> 24-FEB-03 211011290OP 21140320011 2 23410
> 24-FEB-03 211011290OP 26340791011 7 23408
> 27-FEB-03 21108433 26247383011 6
> 29510
> 27-FEB-03 57840320058 20143344011 13 29510
>
> In a few words: I should obtain for the same date, packing-list, item code
> and lot the amount of quantity.
>
> Can anyone help me?
>
> Thanks in advance.
>
> Elena

SELECT field, field, field, SUM(qty)
FROM table
GROUP BY field, field, field;

Look up GROUP BY and HAVING at http://tahiti.oracle.com

Daniel Morgan Received on Mon Mar 10 2003 - 10:12:35 CST