Help on Query

Greetings,

Could somebody help on the following.

Thanks,
Ashoke
 
I have a table with the following values

Lot#  lot_desc  start_date qty
1       Sample  09/02/2005 1
1     Sample      09/03/2005 2
2       Sample  09/02/2005 1
2     Sample      09/03/2005 2
3       Sample  09/02/2005 1
3     Sample      09/03/2005 2
4       Sample  09/02/2005 1
4     Sample      09/03/2005 2
4       Sample  09/04/2005 1
4     Sample      09/05/2005 2

The output must be like the following:

Lot#1 Lot_desc   sum(qty) 09/02/2005  09/03/2005  09/04/2005 09/05/2005
1       Sample  3               1               2
2       Sample  3               1               2
3       Sample  3               1               2
4       Sample  6               1               2               1
2

Is this possible with one single statement? If so, could you please send
me the query.
--
http://www.freelists.org/webpage/oracle-l

Other related posts: