Contents Index COT function [Numeric] CSCONVERT function [STRING]

ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

COUNT function [Aggregate]


Function 

Counts the number of rows in a group depending on the specified parameters.

Syntax 

COUNT (
*
expression
|  DISTINCT { expression | column-name } )

Parameters 

*    Returns the number of rows in each group.

expression    Returns the number of rows in each group where the expression is not the null value.

DISTINCT expression or column-name    Returns the number of different values in the expression, or the column with name column-name. Rows where the value is the NULL value are not included in the count.

Standards and compatibility 
See also 

AVG function [Aggregate]

SUM function [Aggregate]

Example 

The following statement returns each unique city, and the number of rows with that city value:

SELECT city , Count(*)
FROM employee
GROUP BY city

Contents Index COT function [Numeric] CSCONVERT function [STRING]