Unique Function
Function | Description | Examples |
|---|---|---|
UNIQUE | Enables aggregation on a unique field. This function can be applied to only one field in a report template. | COUNT(UNIQUE(client_id)), MAX(UNIQUE(server_id)), job_type FROM apt_job GROUP BY job_type |