Re: union, minus and order by

From: Alroy Mascrenghe <mark_alroy_at_yahoo.co.uk>
Date: Sun, 30 Apr 2000 19:01:00 +0100 (BST)
Message-Id: <10483.104522@fatcity.com>

Gints

  one work around would be to create a view using this selects and then do the order by when selecting records from the view..

Hope this helps

Alroy

• G.Plivna_at_itsystems.lv wrote:
  >
  > Hi!
  >
  > I have SELECT like this
  >
  > SELECT
  > c1.Id ID, c1.Name CNAME, t.name TNAME
  > FROM blabla
  > UNION ALL
  > SELECT
  > c1.Id ID, c1.Name CNAME, t.name TNAME
  > FROM blabla2
  > MINUS
  > SELECT
  > c1.Id ID, c1.Name CNAME, t.name TNAME
  > FROM blabla3
  > ;
  >
  > The problem is how to get rows ordered by these
  > three fields
  >
  > Gints Plivna
  >
  >
  > --
  > Author:
  > INET: G.Plivna_at_itsystems.lv
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >
  

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  >
  

  ---

Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk Received on Sun Apr 30 2000 - 13:01:00 CDT