please look at the below query,
select column1, count(coulmn2) from table1
minus
select column1, count(coulmn2) from table2
In the output, i get two columns i.e column1 and count(column2) after minus operation.
I want the query to display only column1 in the output and not count(column2) but I want it to do the minus operation with both the columns.
Aucun commentaire:
Enregistrer un commentaire