Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Counting Distinct Field Values
Message
From
21/01/2008 10:34:39
Sergey Berezniker
New York, United States
 
 
To
21/01/2008 10:32:36
Steven Dyke
Safran Seats USA
Texas, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Counting Distinct Field Values
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01283647
Message ID:
01283650
Views:
14
This message has been marked as the solution to the initial question of the thread.
>This is probably a repeat question but here goes anyway
>
>I need to Count the number of records from a table on Distinct values of one field other that using the reccount function.
SELECT COUNT(DISTINCT myfield) FROM mytable
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform