What are SQL null functions?

[chirag-garg]

IFNULL(), ISNULL(), NullIF, COALESCE(), and NVL() are the Functions.

The syntax of SQL ISNULL –

1. SELECT column(s), ISNULL(column_name, value_to_replace) FROM table_name;

The Syntax of SQL IFNULL–

1. SELECT column(s), IFNULL(column_name, value_to_replace) FROM table_name;

The Syntax of SQL COALESCE

1. SELECT column(s), CAOLESCE(expression_1,…,expression_n) FROM table_name;

The example of SQL Server NULLIF:

1. SELECT column(s), NULLIF(expression1, expression2) FROM table_name;

The NVL function is available in Oracle is similar to IFNULL:

SELECT SUM (NVL(Sales,100)) FROM Sales_Data;