COUNT(Select_Item) vs COUNT(*)

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

COUNT(Select_Item) vs COUNT(*)

Message

23/06/2004 08:03:58

Sergey Berezniker
New York, États-Unis

23/06/2004 07:08:47

Fabio Lunardon
Lunacom
Marostica, Italie

Information générale

Forum:

Visual FoxPro

Catégorie:

Codage, syntaxe et commandes

Titre:

Re: COUNT(Select_Item) vs COUNT(*)

Divers

Thread ID:

00916320

Message ID:

00916343

Vues:

>
>What's the difference between COUNT(Select_Item) and COUNT(*)?
>
>
>None, except one small difference of time ( COUNT(*) is more fast )
>
<snip>

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

--sb--

Répondre

Fil

Voir

Click here to load this message in the networking platform