# Functions

- [Aggregation Functions](/release-1.4.0/functions/supported-aggregations.md): Aggregate functions return a single result for a group of rows.
- [Transformation Functions](/release-1.4.0/functions/supported-transformations.md): This document contains the list of all the transformation functions supported by Pinot SQL.
- [Array Functions](/release-1.4.0/functions/array-functions.md)
- [Binary Functions](/release-1.4.0/functions/binary-functions.md)
- [DateTime Functions](/release-1.4.0/functions/datetime-functions.md)
- [Funnel Analysis Functions](/release-1.4.0/functions/funnel-analysis.md)
- [GeoSpatial Functions](/release-1.4.0/functions/geospatial-functions.md)
- [Hash Functions](/release-1.4.0/functions/hash-functions.md)
- [JSON Functions](/release-1.4.0/functions/json-queries.md)
- [Math Functions](/release-1.4.0/functions/math-functions.md)
- [String Functions](/release-1.4.0/functions/string-functions.md)
- [User-Defined Functions (UDFs)](/release-1.4.0/functions/scalar-functions.md)
- [URL Functions](/release-1.4.0/functions/url-functions.md)
- [Unique Count and cardinality Estimation Functions](/release-1.4.0/functions/how-to-handle-unique-counting.md): Distinct count