Count()
Used in SELECT
Clause
Use Count()
in a SELECT
clause to see how many records are returned with your query.
You can see how many records a query can return by using Count()
in the SELECT
clause of a query. You can also use Count()
to determine the number of rows returned by a query.
Query:
Response:
Query:
Response:
You can use Count(ContactId)
to determine how many records are available for certain field values in the DatacloudContact object. GROUP BY
is supported for these fields only.
companyName
Department
Level
Title
There are some limitations when using GROUP BY
with the DatacloudContact object.
- DatacloudContact doesn’t support grouping multiple fields. Run separate queries for each field.
- DatacloudContact doesn’t support the rollup or cube operators for
GROUP BY
.
Query:
Response:
Returned records 1–5 of 10916 total records in 0.105 seconds:
Level | Unknown_Field__1 | |
---|---|---|
1 | Staff | 501 |
2 | Manager-Level | 480 |
3 | Director-Level | 69 |
4 | VP-Level | 24 |
5 | C-Level | 16 |