I have a table with 20+ columns and some rows would only have 0s for all the column. Is there a way to filter out rows where all the columns have 0?
I could use
select * from table where CONCAT(col1,col2,col3)!= '000'
but I don’t want to write 20+ zeroes in my case and there is a possibility that the column count could increase in the future.
I could also use
select * from table where COALESCE(col1,col2,col3)>0 or COALESCE(col1,col2,col3)<0
as some values could be negative. But I don’t want to write 20+ column names.
Is there a dynamic way to solve this issue?
You need to sign in to view this answers