Archive
Posts Tagged ‘select’
Case statement in Select clause
September 13, 2011
Leave a comment
Hi,
Below is a sample query that has “CASE statement” in SELECT clause
SELECT EmpID,
CASE
WHEN Salary>=2000 THEN ‘High Salaried’
WHEN Salary<=1000 THEN ‘Medium’
ELSE ‘Below Bar’
END‘New Column’, *
FROM
Employee
Below is the screenshot for reference
Hope it helps 🙂