SQL IFNULL(), ISNULL(), COALESCE(), and NVL() Functions
SQL IFNULL(),ISNULL(), COALESCE(), and NVL() Functions
Suppose that the "UnitsOnOrder" column is optional, and may contain NULL values.
Look at the following SELECT statement:
SELECT ProductName, UnitPrice * (UnitsInStock + UnitsOnOrder)
FROM P...See more
roducts;
In the example above, if any of the "UnitsOnOrder" values are NULL, the result will be NULL.
________________________________________
Views: 1609
Added: 4 years ago
SQL IFNULL.docx
Download
Suggested Creators
Answer the Question