Re: Query to provide range of repeat values

From: VC <boston103_at_hotmail.com>
Date: Fri, 20 Feb 2004 02:48:16 GMT
Message-ID: <QzeZb.356223$xy6.1834583@attbi_s02>

Slight variation on the previous solution:

select min(year) first_year, max(year) last_year, cost from (

    select year, cost, max(rn) over (partition by cost order by year) rn     from
    (
    select year,

           cost,
           case when year - lag(year) over (order by cost, year) != 1
                  then  row_number() over (order by cost)
                when row_number() over (order by cost) = 1
                  then 1
           end rn

    from t1
    )
)
group by cost, rn
order by 1

VC Received on Thu Feb 19 2004 - 20:48:16 CST