mercredi 20 juillet 2016

Counting same data from several column values

i am using sql server 2014.

I have five columns for responses different question, however the different users can possible response the same for different questions.

Getting individual column counts I can do.But how can I get a total of same responses/values from the 5 columns.

Column A    Column B   Column C    Column D    Column E
x           x          y           z           aa
y           z          0           0           0
0           x          x           0           x
aa          bb         0           x           aa

etc

thanks

Aucun commentaire:

Enregistrer un commentaire