Select Non Zero Multiple Columns From Select Statement

Joseph K

9y905SQL

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.