Re: [Firebird-devel] Using DISTINCT and ORDER BY together andunpredictable results

[Milan B. <mi...@pa...>]

Hi Claudio,

Claudio Valderrama C. wrote:
> Since SQL allows to order by a field that doesn't appear in the SELECT list
> (and I can't remember any restriction due to DISTINCT, do you see one in the
> docs?)

Suppose you have a table:

X   Y
--- ---
   1   3
   1   5
   2   4

What should the following query return: SELECT DISTINCT X ORDER BY Y?

1
2

or

2
1

-- 
Milan Babuskov
http://swoes.blogspot.com/
http://www.flamerobin.org