Select Non Zero Multiple Columns From Select Statement

Question

Below is Sql ResultSet Table Dates Col1 Col2 Col3 17-2-2017 0 1 0 18-2-2017 1 1 0 19-2-2017 1 1 0 I have get result like this below Dates col1 col2 17-2-2017 0 1 18-2-2017 1 1 19-2-2017 1 1

Nilesh Shah · Answer

Select * from ResultSet Where Col1 0 OR Col2 2 OR Col3 0