Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Count the records
Message
From
15/04/2008 01:28:44
Khubaib Khalid
Kps
Haroonabad, Pakistan
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Count the records
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01310624
Message ID:
01310624
Views:
62
in my filed (category) records as=A,B,C,A,A,A
I want to count the records.
if A,A,A is replaced continuously
SELECT date,code,lcode,sec, ;
 CAST(sum(IIF(category=="A",1,0)) AS I)	A is 3
Next
Reply
Map
View

Click here to load this message in the networking platform