Re: SQL query

"Elena" <quan.e_at_neologistica.it> wrote in message news:<b4hpe0$mfc$1_at_lacerta.tiscalinet.it>...
> 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.
>

select date, packing_list, item_code, sum(qty), lot from table1
group by date, packing_list, item_code, lot

And please don't see my words as rudeness, but you might need to attend some SQL course.

> Can anyone help me?
>
> Thanks in advance.
>
> Elena
Received on Mon Mar 10 2003 - 12:56:00 CST