Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL SELECT and COUNT - how?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: SQL SELECT and COUNT - how?
Miscellaneous
Thread ID:
00113907
Message ID:
00114058
Views:
19
You must use the COUNT(*) and GROUP BY to achieve this. For example

SELECT *, count(*) FROM yourdb d GROUP by d.source, d.subsource

Costas
Costas Menico
costas@meezon.com
http://www.meezon.com
Previous
Reply
Map
View

Click here to load this message in the networking platform