Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Group by field state
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01367170
Message ID:
01367175
Views:
10
>My survey is finished
>
>I have several states
>
>I would like to count those states without have to commad each line
>
>Something as "group by state".
>
>
>Moses
SELECT State, COUNT(*);
FROM Survey;
GROUP BY State;
INTO CURSOR crsTest
BROWSE NORMAL
Is that what you want?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform