xxxxxxxxxx
SELECT column1, column2,
CASE
WHEN condition1 THEN result1
WHEN condition2 THEN result2
WHEN condition3 THEN result3
ELSE result4
END
FROM tablename;
xxxxxxxxxx
CASE
WHEN condition_1 THEN result_1
WHEN condition_2 THEN result_2
[WHEN ]
[ELSE else_result]
END
xxxxxxxxxx
SELECT column_name,
CASE
WHEN condition1 THEN result1
WHEN condition2 THEN result2
ELSE default_result
END AS result_column
FROM table_name;
xxxxxxxxxx
CASE
WHEN condition_1 THEN result_1
WHEN condition_2 THEN result_2
[WHEN ]
[ELSE else_result]
END
Code language: SQL (Structured Query Language) (sql)
xxxxxxxxxx
SELECT *
FROM Employee
WHERE Emp_ID = CASE WHEN Dept='IT' THEN 1
ELSE 0
END;