In the following query, the CASE expression returns a DECIMAL(38,2) result because the THEN and ELSE clauses contain DECIMAL values:
SELECT SUM (CASE WHEN column_2=1 THEN column_3 * 6 ELSE column_3 END ) FROM dec22;
In the following query, the CASE expression returns a DECIMAL(38,2) result because the THEN and ELSE clauses contain DECIMAL values:
SELECT SUM (CASE WHEN column_2=1 THEN column_3 * 6 ELSE column_3 END ) FROM dec22;