Jeff Johnson wrote:
Let's assume I have a select statement:
SELECT cname, ccity, cnumber sum(1) as groupcount from mytable group
by cname, ccity, cnumber orger by cname
I have to put all of the fields in the group by but the sum will give
me each individual cname, ccity, cnumber which is not what I want.
How do I get just the number of cnames?
VFP9 obviously.
SELECT COUNT(DISTINCT CNAME) FROM MYTABLE
Peter
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
