SQL quiz. Given the <b>cars</b> table: <PRE><CODE>color ----

Given the cars table:

color
-----
blue
red
null
blue

what will be the result of the following query:


SELECT COUNT(DISTINCT color) FROM cars

Explanation

Even though DISTINCT allows for null values, COUNT function does not consider them

or Read more about SQL Quizzes