COUNT
COUNT counts the number of rows in a specified column or table.
Syntax
COUNT (expression)
COUNT (*)
Remarks
• The COUNT (expression) syntax specifies a column.
• The values in the specified column can be of any data type.
• The COUNT (*) syntax returns the count of all rows in a table, including NULL rows.
• If the input is a non-NULL set of values, the output is a positive integer.
• If the input is NULL, the output is zero.
The following table lists the input types that you can use in COUNT, and their corresponding output types.
Data Type of expression | Output Type |
BIGINT, BINARY, BLOB, BOOLEAN, CHAR, CLOB, DATE, DECIMAL, DOUBLE, FLOAT, INTEGER, INTERVAL_DAY, INTERVAL_YEAR, LONGVARCHAR, NUMERIC, REAL, SMALLINT, TIME, TIMESTAMP, TINYINT, VARBINARY, VARCHAR | INTEGER |
NULL | INTEGER with a value of 0 |
Example
SELECT COUNT (products.ProductID) CountColumn
FROM /shared/examples/ds_inventory/products products