Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
COUNT(Select_Item) vs COUNT(*)
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00916320
Message ID:
00916342
Vues:
9
This message has been marked as a message which has helped to the initial question of the thread.
Kamil,

SELECT COUNT(Select_Item) doesn't count records with Null values in Select_Item.

>Hello.
>Help says
>"COUNT(Select_Item) counts the number of select items in a column. COUNT(*) counts the number of rows in the query output. "
>
>OK
>
>Select f1, count(f2) as f2_c from .... group by f1
>and
>Select f1, count(*) as f2_c from .... group by f1
>
>
>Applied against one of my tables both selects yield the same result.
>What's the difference between COUNT(Select_Item) and COUNT(*)?
>Thanks.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform