Example: Returning a DECIMAL(38,2) Result - Teradata Vantage - Analytics Database

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;