select | Rajeev Pentyala - Microsoft Power Platform

Case statement in Select clause

September 13, 2011 Rajeev Pentyala 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

CASE in SELECT Clause

Hope it helps 🙂