COUNT function [Aggregate]

COUNT function [Aggregate]

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

Syntax 1

COUNT( [ * | [ DISTINCT ] expression ] )

Parameters

* Return the number of rows in each group. COUNT(*) and COUNT() are semantically equivalent.
expression Return the number of rows in each group where the value of expression is not null.
DISTINCT expression Return the number of distinct values of expression for all of the rows in each group where expression is not null.

Returns

Remarks

See also

Standards and compatibility

Example

Discuss this page in DocCommentXchange.

Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0