Explanation:
The correct answer is SELECT COUNT(DISTINCT product_name) FROM products. This command accurately counts the distinct product names in the products table. The DISTINCT keyword ensures that each product name is only counted once, regardless of how many times it appears in the table.
Ultimate access to all questions.
Which SQL command correctly returns the count of distinct product names from a Delta table named products?
A
SELECT COUNT(UNIQUE product_name) FROM products
B
SELECT DISTINCT(COUNT product_name) FROM products
C
SELECT COUNT(DISTINCT product_name) FROM products
D
SELECT UNIQUE(COUNT(product_name)) FROM products
E
SELECT DISTINCT(product_name) FROM products
No comments yet.