Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Counting Names
Message
From
28/12/1999 16:06:53
Nancy Folsom
Pixel Dust Industries
Washington, United States
 
 
To
28/12/1999 16:01:04
Rebecca Burlingame
Pima County Superior Court
Tucson, Arizona, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Counting Names
Miscellaneous
Thread ID:
00309467
Message ID:
00309476
Views:
25
Something like this should do it:

select left(cField,1) as letter, count(*) as no from yourTable group by 1
>Is anyone out there a SQL expert? I'm trying to count all the people in my personnel table and group them by first letter of last name. I want my result set to look like this:
> A 203
> B 309
> C 594
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform