PostgreSQL›Numeric Functions›MOD
←TRUNC

MODNumeric Functions

POWER→

Returns the remainder.

Syntax

MOD(n, m)

Example

Enter values below to update the example in real time.

employee_id→
is_even→
employees→
-- 홀수/짝수 분류
SELECT employee_id, MOD(employee_id, 2) AS is_even
FROM employees;