COUNT

COUNT (*) returns the number of rows in the table specified in the FROM clause. COUNT preceding a column name returns the number of rows for which the value is not NULL and can be used with both numeric and non-numeric field-types.

Parameter	Type	Description
`value`	any	the values to be counted, or `*`

Returns: integer

Example

COUNT * query:

SELECT COUNT(*)
  FROM sales_pipeline
 WHERE deal_stage = "Won"

siyeh/sql-crm-example-data Run query Copy code

result:

count
4238

COUNT query:

SELECT COUNT(close_value)
  FROM sales_pipeline

siyeh/sql-crm-example-data Run query Copy code

result:

count
6711