Which SQL statement below will select rows from the products…
Which SQL statement below will select rows from the products table and impute zero where there is a missing value for the column inventory_on_hand. A. SELECT product_id, NVL(inventory_on_hand, 0) as inventory_on_handFROM products; B. SELECT product_id, COALSCE(0, inventory_on_hand) as inventory_on_handFROM products; C. SELECT product_id, COALSCE(inventory_on_hand) as inventory_on_handFROM products;
Read Details