B V, Phanisekhar <[EMAIL PROTECTED]> wrote:
Assume the values in the OR clause, be replaced by some subquery. Then
in such scenarios how will I be able to maintain the order?
I want the order of the subquery to be preserved in the main query.
Show an example. I'd like to look at the ORDER BY clause of that
subquery (it does have one, right)? Then I'll essentially move the ORDER
BY out of the subquery and into the main query.
For e.g.: for the sub query returned values in order (2, 8, 7, 3)
How does the subquery impose this particular order?
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
