SQL Control keywords

The SQL CASE expression provides conditional logic inside queries.

The SQL COALESCE() function returns the first non-NULL value from a list.

The SQL IS NOT NULL operator filters rows where a column contains a non-NULL value.

The SQL IS NULL operator checks whether a value is NULL.

The SQL NULLIF() function returns NULL if two expressions are equal.