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.