Which query would count the number of distinct cities in the 'Customers' table?

SELECT COUNT(*) FROM Customers

SELECT COUNT(DISTINCT City) FROM Customers

SELECT DISTINCT COUNT(City) FROM Customers

SELECT CITY COUNT FROM Customers

COUNT(DISTINCT column) counts only unique values in the specified column, avoiding duplicate counts.

Strengthen Your Practice with our comprehensive question bank.

Get Expert Advice for Free: Register for Your Free Consultation Now!

Full Name

Phone Number

Select Language

Select Course

Please leave this field empty.