Sep 9, 2019 in Spark Sql
Q:

SQL NULL Functions

1 Answer

0 votes
Sep 9, 2019

SQL IFNULL(), ISNULL(), COALESCE(), and NVL() Functions

Look at the following "Products" table:

P_Id ProductName UnitPrice UnitsInStock UnitsOnOrder

1 Jarlsberg 10.45 16 15

2 Mascarpone 32.56 23  

3 Gorgonzola 15.67 9 20

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;

Related questions

0 votes
Sep 9, 2019 in Spark Sql
0 votes
Sep 9, 2019 in Spark Sql
...