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

Home -> Community -> Mailing Lists -> Oracle-L -> union, minus and order by

union, minus and order by

From: <G.Plivna_at_itsystems.lv>
Date: Sun, 30 Apr 2000 18:55:31 +0300
Message-Id: <10483.104520@fatcity.com>


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 Received on Sun Apr 30 2000 - 10:55:31 CDT

Original text of this message

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