Re: DISTINCT ... ORDER BY

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.

Is it possible to add a serial column to my ordered result ?

I hope there is a way to do it without temporary tables as I want to keep
it all in 1 query.

TFYH
--
  e-Trolley Sayegh & John, Nabil Sayegh
  Tel.: 0700 etrolley /// 0700 38765539
  Fax.: +49 69 8299381-8
  PGP : http://www.e-trolley.de