COUNT function [Aggregate]

Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 (Français) » UltraLite - Database Management and Reference » UltraLite SQL reference » UltraLite SQL functions » Functions

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

Discuter à propos de cette page dans DocCommentXchange.

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