Aggregate functions
Aggregate functions in AWS Clean Rooms SQL are used to perform calculations or operations on a group of rows and return a single value. They are essential for data analysis and summarization tasks.
AWS Clean Rooms SQL supports the following aggregate functions:
Topics
- ANY_VALUE function
- APPROXIMATE PERCENTILE_DISC function
- AVG function
- BOOL_AND function
- BOOL_OR function
- COUNT and COUNT DISTINCT functions
- COUNT function
- LISTAGG function
- MAX function
- MEDIAN function
- MIN function
- PERCENTILE_CONT function
- STDDEV_SAMP and STDDEV_POP functions
- SUM and SUM DISTINCT functions
- VAR_SAMP and VAR_POP functions
