APPROXIMATEDISTINCTCOUNT Returns the approximate number of rows that contain distinct values in a column. This function can query large amounts of data with potentially better performance than DISTINCTCOUNT, with slight deviation from the exact result.
column – The column that contains the values to be counted. This cannot be an expression.
The approximate number of distinct values in column.