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