SQL 14: NULL Functions in SQL || How to deal with NULL value for calculation in SQL
In SQL we can create a column based on calculation however if we have null values in any column that will result in to NULL. So, to deal with this kind of situation SQL has following Null Function
1. IFNULL
2. COALESCE
3. NVL