Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Xbase Fox > VFP 9: SQL: cou...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 10 Topic 856 of 861
Post > Topic >>

VFP 9: SQL: count()

by Gene Wirchenko <genew@[EMAIL PROTECTED] > Jul 30, 2008 at 02:41 PM

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.
 




 10 Posts in Topic:
VFP 9: SQL: count()
Gene Wirchenko <genew@  2008-07-30 14:41:24 
Re: VFP 9: SQL: count()
"Dan Freeman" &  2008-07-30 15:07:45 
Re: VFP 9: SQL: count()
Gene Wirchenko <genew@  2008-07-30 16:59:17 
Re: VFP 9: SQL: count()
lemmebe@[EMAIL PROTECTED]  2008-07-30 20:07:52 
Re: VFP 9: SQL: count()
"Dan Freeman" &  2008-07-31 08:49:43 
Re: VFP 9: SQL: count()
Bernhard Sander <fuchs  2008-07-31 11:25:57 
Re: VFP 9: SQL: count()
Gene Wirchenko <genew@  2008-07-31 15:56:33 
Re: VFP 9: SQL: count()
i79947@[EMAIL PROTECTED]   2008-08-01 07:58:47 
Re: VFP 9: SQL: count()
Gene Wirchenko <genew@  2008-08-01 11:21:22 
Re: VFP 9: SQL: count()
Bernhard Sander <fuchs  2008-08-04 11:09:44 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Dec 5 10:10:21 CST 2008.