Re: select changes in row values?

aksel.schmidt wrote:
> hi all
>
> can anyone help me with selecting changes in rows (all inserted in
> bottom/appended)
> tableY:
> columnX
> A
> A
> B
> F
> F
> G
> A
> A
> G
>
> the select should return
> A
> B
> F
> G
> A
> G
>
> it is thus not a distinct, but a distinct 'over time'?
>
> thanks
>
> /aksel

What you are asking makes absolutely no sense to me. You seem to be assuming an ordering to the data ... something precedes something else. That is not supported by your data or by the structure of a heap table.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org