Viewing 2 posts - 1 through 3 (of 3 total)
many many Thanks
Its Working
February 22, 2012 at 2:18 am
#1450125
Use Case statment
SELECT EmpName As EName
case when BasicPay>5000 then 'OVER else 'lOW' end AS Result
FROM EmpSalary
Its also not working
Incorrect syntax near the keyword 'case'.
February 21, 2012 at 11:54 pm
#1450073