1
Reply

Select Non Zero Multiple Columns From Select Statement

Joseph K

Joseph K

Feb 17 2017 8:30 AM
232

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 

Answers (1)