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