Wednesday, 21 August 2013

Select count of 0 from a table

Select count of 0 from a table

I have a table with 400 columns and 200000 rows. I want the count of all
the records that have 0 as their value.
I am not sure how to write the "Select count() from table where 'all 400
attributes' = 0" Select count() from table where attribute' = 0 will give
value for only 1 column. Is there any other way I can select all 0 from
table without manually doing for each attribute? Can anyone please help me
with this?

No comments:

Post a Comment