Mark Forums Read

VFP 9: SQL: count()

Go Back

comp.databases.xbase.fox comp.databases.xbase.fox

Reply

Page 4 of 9

4

#31

Old

Bernhard Sander

Posts: n/a

Re: VFP 9: SQL: count() - 07-31-2008 , 04:25 AM

Hi Gene

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)

or

SELECT Count(DISTINCT clcode) FROM yourTable

Regards
Bernhard Sander

Reply With Quote

#32

Old

Bernhard Sander

Posts: n/a

Re: VFP 9: SQL: count() - 07-31-2008 , 04:25 AM

Hi Gene

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)

or

SELECT Count(DISTINCT clcode) FROM yourTable

Regards
Bernhard Sander

Reply With Quote

#33

Old

Bernhard Sander

Posts: n/a

Re: VFP 9: SQL: count() - 07-31-2008 , 04:25 AM

Hi Gene

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)

or

SELECT Count(DISTINCT clcode) FROM yourTable

Regards
Bernhard Sander

Reply With Quote

#34

Old

Bernhard Sander

Posts: n/a

Re: VFP 9: SQL: count() - 07-31-2008 , 04:25 AM

Hi Gene

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)

or

SELECT Count(DISTINCT clcode) FROM yourTable

Regards
Bernhard Sander

Reply With Quote

#35

Old

Bernhard Sander

Posts: n/a

Re: VFP 9: SQL: count() - 07-31-2008 , 04:25 AM

Hi Gene

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)

or

SELECT Count(DISTINCT clcode) FROM yourTable

Regards
Bernhard Sander

Reply With Quote

#36

Old

Bernhard Sander

Posts: n/a

Re: VFP 9: SQL: count() - 07-31-2008 , 04:25 AM

Hi Gene

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)

or

SELECT Count(DISTINCT clcode) FROM yourTable

Regards
Bernhard Sander

Reply With Quote

#37

Old

Bernhard Sander

Posts: n/a

Re: VFP 9: SQL: count() - 07-31-2008 , 04:25 AM

Hi Gene

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)

or

SELECT Count(DISTINCT clcode) FROM yourTable

Regards
Bernhard Sander

Reply With Quote

#38

Old

Dan Freeman

Posts: n/a

Re: VFP 9: SQL: count() - 07-31-2008 , 10:49 AM

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

Reply With Quote

#39

Old

Dan Freeman

Posts: n/a

Re: VFP 9: SQL: count() - 07-31-2008 , 10:49 AM

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

Reply With Quote

#40

Old

Dan Freeman

Posts: n/a

Re: VFP 9: SQL: count() - 07-31-2008 , 10:49 AM

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

Reply With Quote

Reply

Page 4 of 9

4

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.