PostgreSQLAggregate FunctionsBOOL_OR
BOOL_AND

BOOL_ORAggregate Functions

BIT_AND

Returns true if any value is true.

Syntax

BOOL_OR(expr)

Example

Enter values below to update the example in real time.

department_id
is_remote
has_remote
employees
-- 한 명이라도 원격 근무 중인 부서
SELECT department_id, BOOL_OR(is_remote) AS has_remote
FROM employees
GROUP BY department_id;