I am trying to compare two external tables using
select * from table1
minus
select * from table2
I know that the minus removes the duplicate values, but I would like to have ALL rows which are different returned, including duplicates so I can get an idea of how different the tables are.
Thread
1856459
covers this, but I am not familiar with analytical SQL, so I don't know how to translate Elic's solution of select name, into a solution of select *. I've tried by explicitly naming all the columns (which I would rather not do), but am getting an error about a missing order by expression. Anyone suggest how to implement the solution with a select * query?