Categories: Aggregate
APPROX_COUNT_DISTINCT
Returns the approximate number of rows that contain distinct values in a column. Ignores rows that contain a null value for the column.
Syntax
APPROX_COUNT_DISTINCT(column_name ANY) → INT or BIGINT
- column_name: The column can contain values of any data type.
Examples
SELECT APPROX_COUNT_DISTINCT(business_id) AS "number_of_businesses" FROM "restaurant_reviews.parquet";
-- 62
Was this page helpful?
Glad to hear it! Thank you for your feedback.
Sorry to hear that. Thank you for your feedback.