Answer-first summary for fast verification
Answer: SELECT COUNT(DISTINCT product_name) FROM products
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.
Author: LeetQuiz Editorial Team
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.