Searched CASE function
Syntax
CASE
WHEN Boolean_expression THEN result_expression
[ ...n ]
[
ELSE else_result_expression
]
END
Examples
• SELECT title, 'Movie Type' =
CASE
WHEN movie_description LIKE '%Horror%' THEN 'Horror'
WHEN movie_description LIKE '%Adventure%' THEN 'Adventure'
ELSE 'Family'
END
FROM movie_titles;
• SELECT COUNT(empno), MAX(sal) FROM emp GROUP BY CASE WHEN deptno > 5 THEN deptno ELSE deptno + 10 END;
• SELECT * FROM emp ORDER BY CASE WHEN MOD(deptno, 2)>=1 THEN 'Group 1' ELSE 'Group 2' END;
• SELECT COUNT(*), deptno FROM emp GROUP BY deptno HAVING CASE WHEN MOD(deptno, 2)>=1 THEN MAX(sal) ELSE MAX(comm) END > AVG(sal);
