• SELECT ID=ID,

    NAME=NAME,

    SALARY=SALARY,

    SALARY2=(case when SALARY-1000=0 then null else SALARY-1000 end)

    FROM SalaryDetail