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