Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Query - 2nd Request Pls Help

RE: Query - 2nd Request Pls Help

From: salu Ullah <>
Date: Mon, 19 Jun 2000 19:48:19 GMT
Message-Id: <>

Hello David,

I have to create a report that should show cust_id, item_code, its status with from_date & to_date based on purc_date column. If u look at the result its showing the cust_id (0001), item_code (AAAA), from_date (01-JAN-00), to_date (03-JAN-00) for status (A) & then with same cust_id, item_code, but then from_date & to_date is (04-JAN-00 05-JAN-00) because on these 2 days the status was B.
I hope i answer ur question. I want to group them so that each cust_id with its item_code & status should show from & to date.

Any help is appreciated.


>From: "Shockey, David" <>
>To: Multiple recipients of list ORACLE-L <>
>Subject: RE: Query - 2nd Request Pls Help
>Date: Mon, 19 Jun 2000 09:31:30 -0800
>You'll have to give us the logic behind your desired results. As it is,
>have lines that have the same cust_id, item_code, and status in the
>So, a simple grouping on these fields is not possible. What other grouping
>criteria are you using?
>-----Original Message-----
>Sent: Monday, June 19, 2000 10:48 AM
>To: Multiple recipients of list ORACLE-L
>I have a table with columns & data as follows
>cust_id item_code purc_date status
>0001 AAAA 01-JAN-00 A
>0001 AAAA 02-JAN-00 A
>0001 AAAA 03-JAN-00 A
>0001 AAAA 04-JAN-00 B
>0001 AAAA 05-JAN-00 B
>0002 BBBB 05-JAN-00 A
>0001 AAAA 06-JAN-00 A
>0002 BBBB 06-JAN-00 A
>0001 AAAA 07-JAN-00 A
>. . . .
>. . . .
>0001 AAAA 29-JAN-00 A
>0001 AAAA 30-JAN-00 B
>0001 AAAA 31-JAN-00 B
>I'am looking for a query that will give the folllowing result:
>cust_id item_code status from_date to_date
>0001 AAAA A 01-JAN-00 03-JAN-00
>0001 AAAA B 04-JAN-00 05-JAN-00
>0002 BBBB A 05-JAN-00 06-JAN-00
>0001 AAAA A 06-JAN-00 29-JAN-00
>0001 AAAA B 30-JAN-00 31-JAN-00
>I tried using min(purc_date) & max(purc_date) & grouping them with the
>remaining columns,
>but was not getting the desired output.
>Any input will be appreciated. Thanks in advance
>Get Your Private, Free E-mail from MSN Hotmail at
>Author: salu Ullah
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

Received on Mon Jun 19 2000 - 14:48:19 CDT

Original text of this message