APPROX_COUNT_DISTINCT

Introduction

APPROX_COUNT_DISTINCT:count approximate distinct values

Synopsis

APPROX_COUNT_DISTINCT ( column )

Parameters

column: the column needed to be counted against

Example

SELECT APPROX_COUNT_DISTINCT ( O_CUSTKEY ) FROM ORDERS;