Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

query

591309Mar 4 2009 — edited Mar 11 2009
HI 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 1 2009
Added on Mar 4 2009
2 comments
1,185 views