Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Number of unique records in one (sql) command?
Message
From
28/06/2007 15:36:45
Rich Pupko
Retired
Henderson, Nevada, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Number of unique records in one (sql) command?
Miscellaneous
Thread ID:
01236514
Message ID:
01236543
Views:
24
This message has been marked as the solution to the initial question of the thread.
>Hi all,
>
>Is there a (sql) command that can calculate the number of unique records of a field into a table with just one command in VFP 5?
>
>Thanks beforehand.

How about
SELECT COUNT (DISTINCT yourfield) FROM yourTable INTO ARRAY aTemp
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform