Category: ASE: Functions: Aggregate Functions

count(*)

The aggregate function count(*) counts all rows of a table even if there values are NULL .

Syntax of the Aggregate Function count(*)

    count(*)
    

The parameters of the aggregate function count()

all
"all" counts all values. "all" is the default parameter of the function count().

distinct
"distinct" ignores duplicate values in the output of count(). "distinct" is an optional parameter.

expression
"expression" usually serves as a placeholder for a column name in the count()-function.

Example for the Aggregate Function count(*)

Returns the number of rows of the table table_name.

    select count(*) from table_name
    

See also:

ASE T-SQL - Aggregate Functions,
avg(),
count(),
count_big(),
max(),
min(),
sum().