Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
COUNT(Select_Item) vs COUNT(*)
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00916320
Message ID:
00916342
Views:
8
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform