APPROX_COUNT_DISTINCT
Last updated
Last updated
Approximates the number of distinct non-null input values.
This function is used as an approximation of in order to improve performance. It should be used when there are relatively few (under one million) rows, and where the total number of distinct values is high.
X
Type: any type
The values to be counted.
Type: bigint
Returns the approximate number of distinct non-null input values.
If all input values are null, zero is returned.
pickup
1062.14
shipping
1061.91