Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> union, minus and order by
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
![]() |
![]() |