Help on Query
- From: "Mandal, Ashoke" <ashoke.k.mandal@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 8 Sep 2005 12:30:38 -0500
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
