Home Forums SQL Server 2008 T-SQL (SS2K8) Reg: Interview Questions RE: Reg: Interview Questions
carlosaamaral
Old Hand
Points: 325
More actions
November 7, 2012 at 3:26 am
#1556693
SELECT ID=ID,
NAME=NAME,
SALARY=SALARY,
SALARY2=(case when SALARY-1000=0 then null else SALARY-1000 end)
FROM SalaryDetail