My SQL Tutorials - Distinct Count
Counting Specific Data Values (COUNT(Distict Variable)):
The COUNT(Distinct Variable) column function counts the number of records within a given table. The data within this table can be of any data type. The COUNT(Distinct Variable) function always returns an integer. Here is an example of the COUNT(Distinct Variable) column function...
Select Count(Distinct Book_Title)
From BookLength_Table
Where BookLength equals "Big";