query
591309Mar 4 2009 — edited Mar 11 2009HI all,
I have atable with 25 columns.
a b -------------y
no yes no
no yes yes
yes no no
I have to calculate how many yes and no are there in each column.The output should be
status a b----------------upto y
NO 2 1 2
YES 1 2 1
How can iachieve this in single query?
THanks