how to count separate column in this Query.

Posted by Jayakumars under Sql Server on 10/17/2012 | Points: 10 | Views : 726 | Status : [Member] [MVP] | Replies : 1
hi
my Query output like this see the image attachment

id Q1 Q2 Q3 Q4 Q5
============================
1 65 1 2 0 2
2 1 2 2 0 1
3 2 1 1 1 2
4 1 1 2 0 1
5 2 2 0 0 2
6 2 0 1 1 1

i need here how much 1 and how much 2 and other value in Q1 and Q2 etc but
i need each column 3 output how much 1 and howmuch 2 and how much other value how to count and show other column .

Mark as Answer if its helpful to you


Responses

Posted by: Gaur1982 on: 10/18/2012 [Member] Starter | Points: 25

Up
0
Down
Will you please explain you question.... What exactly you want...
and there is no image attach... only a zip file attached which is invalid and not to open.....

Gaurav Agrawal
http://www.planetofcoders.com/

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response