Re: DISTINCT ... ORDER BY

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.