Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Minus with order by

2942624Nov 28 2017 — edited Nov 28 2017

Hi,

I am trying to do minus with order by which is giving error.

select * from ADJ order by account

minus

select * from CADJ order by account;

error:

ORA-00933: SQL command not properly ended

00933. 00000 -  "SQL command not properly ended"

Can any one suggest how to get minus to 2 tables with order by

select * from ADJ

minus

select * from CADJ order by account;  -- Is giving incorrect result

This post has been answered by AndrewSayer on Nov 28 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 26 2017
Added on Nov 28 2017
9 comments
2,683 views