Need help on a query with analytics
From: FRITSCH Vincent <fritschvince_at_yahoo.fr>
Date: 22 Feb 2004 21:34:38 -0800
Message-ID: <b220bc5e.0402222134.3ac12a71_at_posting.google.com>
Date: 22 Feb 2004 21:34:38 -0800
Message-ID: <b220bc5e.0402222134.3ac12a71_at_posting.google.com>
Hi,
i need help on a query.
I've this table :
create table t (
customer number(5),
time date,
status varchar2(1)
)
/
insert into t values (1,to_date('20030101','yyyymmdd'),1);
insert into t values (1,to_date('20030121','yyyymmdd'),0);
insert into t values (1,to_date('20030803','yyyymmdd'),1);
insert into t values (1,to_date('20030909','yyyymmdd'),1);
insert into t values (1,to_date('20031201','yyyymmdd'),0);
CUSTOMER S BEGIN_ END_
--------- - -------- --------
1 1 01/01/03 21/01/03 1 0 21/01/03 03/08/03 1 1 03/08/03 09/09/03 1 1 09/09/03 01/12/03 1 0 01/12/03
but this is not exactly what i search (lines 3 and 4 need to be merge)
Analytics functions can be useful here ? Can someone help me ?
Thanks in advance Received on Mon Feb 23 2004 - 06:34:38 CET