Post
Ask Question
Joseph K

Joseph K

  • NA
  • 255
  • 28.4k

Select Non Zero Multiple Columns From Select Statement

Feb 17 2017 8:30 AM

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)