Select from following answers:- SELECT product_Id, product_name, product_description COALESCE(price, 0) as 'price' FROM product;
- SELECT product_Id, product_name, product_description, price FROM product where price is not null;
- SELECT product_Id, product_name, product_description, price FROM product where price is null;
- All Above
COALESCE function will replace all NULL values in the MaxQty column with the value 0.
Show Correct Answer
Asked In: measureup.com |
Alert Moderator