Hi,
>> Is there any constraint with ORDER BY inside sub queries?
Yes.
For instance, You cannot specify an order_by_clause in the subquery of set operators.
But, I don't remember having read something similar for the membership_condition. (ie IN / NOT IN )
>> The above mentioned query is not executing in Oracle.
Understandable.
We don't get anything by ordering the set used with IN.
i) id in (2,4,5)
ii) id in (4,5,2)
both are functionally equivalent.
May be, for this reason, order_by_clause is not allowed here.
-----------------------------------
Rate the reply if you find it helpful
|