COALESCE

Applies to: sql

COALESCE returns the first non-null value from its arguments, useful for defaults.

SELECT COALESCE(nickname, name) FROM users;

See also: null, missing-value