oracle sql count multiple columns
Problem: I want to count the number of columns that have a certain value in sql.
Example: 
       A   B  C D  E
       1   2  1  2 2

How can I count that there are 3 columns have the value 2. 

thanks!


oracle sql count multiple columns
===

Problem: I want to count the number of columns that have a certain value in sql.
Example: 
       A   B  C D  E
       1   2  1  2 2

How can I count that there are 3 columns have the value 2. 

thanks!

