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
Kumaraspcode2009@gmail.com