Re: Analytic troubles

From: hrishy <hrishys@xxxxxxxxxxx>
To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>, Yavor_Ivanov@xxxxxxxx
Date: Mon, 10 Nov 2008 10:16:33 +0000 (GMT)

Hi

Does this work.
From the top of my head didnt test

select min(date_form),name
from (
select  date_form,
        name,
        lead(name,1,0)
        over(order by date_form) next_name
from   table1 
) x
where (x.name=x.next_name OR x.name<>x.next_name)
group by name

regards
Hrishy





      
--
//www.freelists.org/webpage/oracle-l

References:
- Analytic troubles
  - From: Yavor Ivanov

Other related posts:

» Analytic troubles- Yavor Ivanov
» Re: Analytic troubles- jo_holvoet
» Re: Analytic troubles- Ian Cary
» Re: Analytic troubles - hrishy
» RE: Analytic troubles- Yavor Ivanov