I have a minus sql query which have multiple columns and its result is 8 rows, so how can i understand these fallout is popup for which column
Ex
Select col1 , col2 , col3,,,,,,,coln from table1
minus
select col1 , col2 , col3,,,,,,,coln from table2
output is
1,2,3,4,5,6,,,,,,n
2,3,4,5,6,7,,,,,,n
Now how can i findout which table1 column value is different from table2
i don’t want to do it manually
i want some sql solution of my problem
Govind Kapoor is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.