Create a new column based on calculation from another column of same table

1

Hi, I want to create a new column (let is called as X) from a column (name Y). X is in Int and Y is in float. The formula is if Y >= 84 then x=Y-84, or if Y<84, then X = Y.

Thank You.

2 
case 
     when Y >=84 then Y-84 
     else  Y end 
as  X
2 Likes
3

Hi Harish, I tried this and it executed. But once again when i tried to find sum of x, it showing sum of Y. which is wrong.

4 
SUM (
    case  when Y >=84 then Y-84  else  Y end 
    ) 
AS SUM_X
5

In SQL Server, you can genuniely create another column in your query using a CROSS APPLY:


SELECT SUM(X) AS sum_x
FROM table_name tn
CROSS APPLY (
    SELECT CASE WHEN Y >= 84 THEN Y - 84 ELSE Y END AS X
) AS ca1