SQLPathLab

Conditions and NULL

5 items
Filters
Clear filters
Conditions and NULL
Conditions and NULL · Basic

CASE WHEN

Returns different values based on conditions.

 Conditions and NULL · Basic

COALESCE

returning the first non-null value.

 Conditions and NULL · Basic

IFNULL

replacing NULL with a default value.

 Conditions and NULL · Basic

NULLIF

returning NULL when two values are equal.

 Conditions and NULL · Intermediate

CAST

converting data types