How do I, in one query, get the count of the number of distinct
values for a particular column? For example:
clcode other
------ -----
ABC 12
ABC 34
DEF 17
DEF 21
DEF 58
GHI 29

The result that I want is the number of different clcode values in
the above: 3.

I thought I had done this before with but one query, but can not
figure it out now.

Have I been bitten by a bitrot bug or something?

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.

Select clcode Group by clcode
?_tally

Dan

Gene Wirchenko wrote:

Select clcode Group by clcode
?_tally

Dan

Gene Wirchenko wrote:

Select clcode Group by clcode
?_tally

Dan

Gene Wirchenko wrote:

Select clcode Group by clcode
?_tally

Dan

Gene Wirchenko wrote:

Select clcode Group by clcode
?_tally

Dan

Gene Wirchenko wrote:

Select clcode Group by clcode
?_tally

Dan

Gene Wirchenko wrote:

Select clcode Group by clcode
?_tally

Dan

Gene Wirchenko wrote:

Select clcode Group by clcode
?_tally

Dan

Gene Wirchenko wrote:

Select clcode Group by clcode
?_tally

Dan

Gene Wirchenko wrote: