VFP 9: SQL: count()

#41

Gene Wirchenko wrote:

Quote:

"Dan Freeman" <spam (AT) microsoft (DOT) com> wrote:

Select clcode Group by clcode
?_tally

Blindsided again. I use _tally quite often, and I did not even
think of doing this.

Thank you.

You're welcome. As Bernhard posts, there are other ways.

One of the great things about VFP is there are always 3 ways to do any given
thing. One of the worst things about VFP is there are always 3 ways to do
any given thing. <g>

Dan

#42

Gene Wirchenko wrote:

Quote:

"Dan Freeman" <spam (AT) microsoft (DOT) com> wrote:

Select clcode Group by clcode
?_tally

Blindsided again. I use _tally quite often, and I did not even
think of doing this.

Thank you.

You're welcome. As Bernhard posts, there are other ways.

One of the great things about VFP is there are always 3 ways to do any given
thing. One of the worst things about VFP is there are always 3 ways to do
any given thing. <g>

Dan

#43

Gene Wirchenko wrote:

Quote:

"Dan Freeman" <spam (AT) microsoft (DOT) com> wrote:

Select clcode Group by clcode
?_tally

Blindsided again. I use _tally quite often, and I did not even
think of doing this.

Thank you.

You're welcome. As Bernhard posts, there are other ways.

One of the great things about VFP is there are always 3 ways to do any given
thing. One of the worst things about VFP is there are always 3 ways to do
any given thing. <g>

Dan

#44

Gene Wirchenko wrote:

Quote:

"Dan Freeman" <spam (AT) microsoft (DOT) com> wrote:

Select clcode Group by clcode
?_tally

Blindsided again. I use _tally quite often, and I did not even
think of doing this.

Thank you.

You're welcome. As Bernhard posts, there are other ways.

One of the great things about VFP is there are always 3 ways to do any given
thing. One of the worst things about VFP is there are always 3 ways to do
any given thing. <g>

Dan

#45

Gene Wirchenko wrote:

Quote:

"Dan Freeman" <spam (AT) microsoft (DOT) com> wrote:

Select clcode Group by clcode
?_tally

Blindsided again. I use _tally quite often, and I did not even
think of doing this.

Thank you.

You're welcome. As Bernhard posts, there are other ways.

One of the great things about VFP is there are always 3 ways to do any given
thing. One of the worst things about VFP is there are always 3 ways to do
any given thing. <g>

Dan

#46

Gene Wirchenko wrote:

Quote:

"Dan Freeman" <spam (AT) microsoft (DOT) com> wrote:

Select clcode Group by clcode
?_tally

Blindsided again. I use _tally quite often, and I did not even
think of doing this.

Thank you.

You're welcome. As Bernhard posts, there are other ways.

One of the great things about VFP is there are always 3 ways to do any given
thing. One of the worst things about VFP is there are always 3 ways to do
any given thing. <g>

Dan

#47

Bernhard Sander <fuchs (AT) no (DOT) spam> wrote:

Quote:

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.

SELECT count(*) FROM (SELECT clcode FROM yourTable GROUP BY clCode)

I tried this one before posting: Syntax error. I thought it
would work, too. Does anyone know what is wrong with it?

Quote:

or

SELECT Count(DISTINCT clcode) FROM yourTable

Sincerely,

Gene Wirchenko

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

#48

Bernhard Sander <fuchs (AT) no (DOT) spam> wrote:

Quote:

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.

SELECT count(*) FROM (SELECT clcode FROM yourTable GROUP BY clCode)

I tried this one before posting: Syntax error. I thought it
would work, too. Does anyone know what is wrong with it?

Quote:

or

SELECT Count(DISTINCT clcode) FROM yourTable

Sincerely,

Gene Wirchenko

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

#49

Bernhard Sander <fuchs (AT) no (DOT) spam> wrote:

Quote:

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.

SELECT count(*) FROM (SELECT clcode FROM yourTable GROUP BY clCode)

I tried this one before posting: Syntax error. I thought it
would work, too. Does anyone know what is wrong with it?

Quote:

or

SELECT Count(DISTINCT clcode) FROM yourTable

Sincerely,

Gene Wirchenko

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

#50

Bernhard Sander <fuchs (AT) no (DOT) spam> wrote:

Quote:

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.

SELECT count(*) FROM (SELECT clcode FROM yourTable GROUP BY clCode)

I tried this one before posting: Syntax error. I thought it
would work, too. Does anyone know what is wrong with it?

Quote:

or

SELECT Count(DISTINCT clcode) FROM yourTable

Sincerely,

Gene Wirchenko

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