As we saw in the last article, the SQL SELECT statement has the widest variety of query options, ... COUNT can also be applied to count the number of rows in a DISTINCT result set. SELECT COUNT ...