The following table describes the required columns of the input table. The input table can have additional columns, but the function ignores them.
Column Name | Data Type | Description |
---|---|---|
target_column | SMALLINT, INTEGER, BIGINT, NUMERIC, or DOUBLE PRECISION | Column for which to compute the approximate percentile. |
group_column | INTEGER or VARCHAR | Column by which to group the data. |