SQL - Using COALESCE To Set Default Values

6th May 2020

2 min read

Syntactic sugar for a CASE expression
Arguments must be of the same type
Checks if the first argument is null. If it is, it checks the next argument, until a not null value is found.

1SELECT COALESCE (table.rates,'0.00')

Elle Hallal

(she / her)

Software Crafter at 8th Light, and Leadership Team Member and Mentor at Coding Black Females.

Note: views expressed do not represent any associated organisations.