Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: UNION ALL and ordering

Re: UNION ALL and ordering

From: Arch <send.no_at_spam.net>
Date: Fri, 23 Nov 2007 14:12:12 -0500
Message-ID: <999ek3p6siaq487m4k214o2sk5g02rdtav@4ax.com> 





On Fri, 23 Nov 2007 14:52:20 GMT, "Ravip via DBMonster.com"
<u36659_at_uwe> wrote:



>By default the output will be result of first select and then second select.




Are you certain that is correct?  I  believe the SQL specification
says that only the final ORDER BY is significant in UNION queries.
Received on Fri Nov 23 2007 - 13:12:12 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US