lundi 7 mars 2016

Select one column from output with multiple columns

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