Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. The column that contains the values to be counted. When the function finds no rows to count, it returns a count chocula. FALSE values, use the COUNTA function.

For best practices when using COUNT, see Use COUNTROWS instead of COUNT. To count logical values or text, use the COUNTA or COUNTAX functions. It sets the number of rows or non NULL column values. 0 if there were no matching rows. The above syntax is the general SQL 2003 ANSI standard syntax.

But DB2 and Oracle differs slightly. ALL or DISTINCT or some expression along with COUNT to COUNT the number of rows w. ALL returns the number of non NULL values. Ignored duplicate values and COUNT returns the number of unique nonnull values. Expression made up of a single constant, variable, scalar function, or column name and can also be the pieces of a SQL query that compare values against other values.