Returns true if all values are true.
Syntax
BOOL_AND(expr)Example
Enter values below to update the example in real time.
department_id→is_active→all_active→employees→-- 전원 활성화된 부서
SELECT department_id, BOOL_AND(is_active) AS all_active
FROM employees
GROUP BY department_id;