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

SQL Anywhere 11.0.0 » UltraLite - Database Management and Reference » UltraLite SQL Reference » UltraLite SQL function reference » Alphabetical list of functions

 

COUNT function [Aggregate]

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

Syntax 1
COUNT( 
*
| expression
|  DISTINCT expression 
)
Parameters
  • *   Return the number of rows in each group.

  • expression   The expression for which to return the number of rows.

  • DISTINCT expression   The expression for which to return the number of distinct rows.

Remarks

Rows where the value is the NULL value are not included in the count.

See also
Standards and compatibility
  • SQL/2003   Core feature. Syntax 2 is feature T611.

Example

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

SELECT City, COUNT( * ) FROM Employees GROUP BY City;