IFNULL in SQL - sql - sql tutorial - learn sql
- MySQL IFNULL function is one of the MySQL control flow functions that accepts two arguments and returns the first argument if it is not NULL. Otherwise, the IFNULL function returns the second argument.
- The IFNULL( ) function is available only in MySQL, and not in SQL Server or Oracle.
- This function takes two arguments. If the first argument is not NULL, the function returns the first argument.
- Otherwise, the second argument is returned. This function is commonly used to replace NULL value with another value.
- It is similar to the NVL function in Oracle and the ISNULL Function in SQL Server.
Tags : sql tutorial , pl sql tutorial , mysql tutorial , oracle tutorial , learn sql , sql server tutorialSyntax:
Syntax:
IFNULL(expression1, expression2);
Example 1: MySQL IFNULL() function
- The following MySQL statement returns the first expression, i.e. 0, since the first expression is not NULL.
1. SELECT IFNULL(0,2);
Output :
mysql> SELECT IFNULL(0,2);
+-------------+
| IFNULL(0,2) |
+-------------+
| 0 |
+-------------+
1 row in set (0.03 sec)
Example 2: IFNULL() function with non zero 1st argument
- The following MySQL statement returns the first expression, i.e. 1, since the first expression is not NULL.
SELECT IFNULL(1,2);
Output :
mysql> SELECT IFNULL(1,2);
+-------------+
| IFNULL(1,2) |
+-------------+
| 1 |
+-------------+
1 row in set (0.00 sec)
Tags : sql tutorial , pl sql tutorial , mysql tutorial , oracle tutorial , learn sql , sql server tutorialExample 3: IFNULL() function NULL
Example 3: IFNULL() function NULL
- The following MySQL statement returns the second expression, i.e. 2, since the first expression is NULL.
SELECT IFNULL(NULL,2);
Output :
mysql> SELECT IFNULL(NULL,2);
+----------------+
| IFNULL(NULL,2) |
+----------------+
| 2 |
+----------------+
1 row in set (0.00 sec)