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 Products; In the example above, if any of the "UnitsOnOrder" values are NULL, the result will be NULL. ________________________________________

SQL IFNULL() +6 more

by yash sharma

Stash 0

1 Attachment 4 years ago