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