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.
companyNameDepartmentLevelTitle
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 |