Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why Two Different Return Counts
Message
De
11/09/2007 13:24:19
Steven Dyke
Safran Seats USA
Texas, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Why Two Different Return Counts
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01253728
Message ID:
01253728
Vues:
62
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform