I have one table view_Qts_case_errors in the table in have five columns MP,AP,GE,IE,PG. I am trying to apply a filter and get the results in same table or single column. My requirement is
1.Mp >0 or AP>0,2.GE >0,3.IE > 0,4.PG>0,
I tried case statement but am not getting expected output in my query