select changes in row values?

From: "aksel.schmidt" <axl.schmidt@xxxxxxxxx>
Date: Wed, 27 Jun 2007 14:42:33 -0700

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

.

Follow-Ups:
- Re: select changes in row values?
  - From: DA Morgan

Prev by Date: Re: simple sql using between startnumber and endnumber not performing
Next by Date: Re: simple sql using between startnumber and endnumber not performing
Previous by thread: function in select and where clause - performance
Next by thread: Re: select changes in row values?
Index(es):
- Date
- Thread