Category: ASE: Functions: Aggregate Functions

count()

The aggregate function count() counts all rows of a table the values of which are not NULL .

Syntax of the aggregate function count()

    count( [ all | distinct ] expression )
    

Example for the aggregate function count()

Returns the number of all rows for the column column_name of the table table_name, the values of which are not equal to NULL.

    select count(column_name) from table_name
    

See also:

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