Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Distinct clause
Message
 
To
21/02/2000 14:58:51
William Caputo
Thoughtworks
Chicago, Illinois, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Distinct clause
Miscellaneous
Thread ID:
00334970
Message ID:
00334988
Views:
27
Try this:

SELECT repid, count(repid) as FieldCnt distinct from table1 group by 1
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform