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--