SQL 2023 · Querying
Replace NULL with a default
Return the first value that isn't NULL.
SELECT COALESCE(nickname, name) AS display_name FROM users;
Official SQL 2023 documentation
SQL 2023 · Querying
Return the first value that isn't NULL.
SELECT COALESCE(nickname, name) AS display_name FROM users;
Official SQL 2023 documentation
Was this page helpful?