Re: Baffling SQL failure in Oracle - anyone explain?

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Sat, 13 Aug 2005 18:26:15 +0200
Message-ID: <ddl6u0$3g8$02$1@news.t-online.com>

Sybrand Bakker schrieb:
> On Sat, 13 Aug 2005 16:14:49 +0100, Paul <paul_at_see.my.sig.com> wrote:
>
>

>>Now, I can't for the life of me figure out why this query is failing
>>in Oracle - I think that it's perfectly reasonable to sort on a column
>>that one isn't selecting on. 

>
>
> I don't agree. It is pretty useless to order on sal when you don't
> display the sal. Oracle agrees with me.
> Oracle != Sqlserver and whatever toy products are available .
>
> --
> Sybrand Bakker, Senior Oracle DBA

I'd rather suggest , the reason is somewhat another... The restriction applies only with DISTINCT keyword, without it you can order by not displayed columns.

Best regards

Maxim Received on Sat Aug 13 2005 - 11:26:15 CDT