Is there any way to write a case statement in sql, if column A >0 then column B, Column C= 0
I’ve multiple columns which has the same value and it is showing incorrect results when I summarize them. Is there any way to write a case statement in sql, if column A >0 then make all remaining columns as 0 (column B, Column C, Column D= 0) if column B >0 then make all remaining… Read More Is there any way to write a case statement in sql, if column A >0 then column B, Column C= 0