Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why Two Different Return Counts
Message
From
11/09/2007 13:24:19
Steven Dyke
Safran Seats USA
Texas, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Why Two Different Return Counts
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01253728
Message ID:
01253728
Views:
63
Why would to two following SQL statements return different record counts?

sqla = "SELECT Count(*) As rCount FROM webprddt6.tsotagtbl Where archivef = '0' Group By cono"

sql = "SELECT cono, archivef FROM webprddt6.tsotagtbl Where archivef = '0' Group By cono, archivef"

The first returns 128

The second 133
Next
Reply
Map
View

Click here to load this message in the networking platform