On Wed, 5 Nov 2003, Nabil Sayegh wrote:
> Stephan Szabo wrote:
>
> > Your step 3 above isn't well defined in general. There's no single place
> > in the sort order for a value of a column being distincted when the value
> > occurs multiple times. In the data above, col1='b' occurs twice in the
> > sort order and you need to give an indication of which place in the sort
> > order you want to use.
>
> Ok, let's look for alternatives.
Well, what did you get when you tried something like Bruno's updated
example or my group by one, and lets work from there.