Hi all,
I have built a query that mainly orders all columns.
It shouldn't matter how it orders but FYI:
I need to order by 1 given column and then by all others from 'left to right'.
No problem so far.
Then I want to return only 1 column (e.g. the 3rd) with duplicates removed
_AND_ still in the same order like above.
e.g.:
myCol
-----
a
a
c
b
b
c
b
should return:
myDistinctOrderedCol
--------------------
a
c
b
The problem is that DISTINCT complains about ORDER BY entries not being in the target list.
Any idea ?
Example:
initial query:
SELECT * FROM tab ORDER BY col_2='foo' DESC, col_1='bar' DESC, col_3='blah' DESC;
Then something like:
SELECT DISTINCT col3 FROM {initial query};
TIA
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de
