---
title: View InfluxQL functions
description: Aggregate, select, transform, and predict data with InfluxQL functions.
url: https://docs.influxdata.com/influxdb3/cloud-dedicated/reference/influxql/functions/
estimated_tokens: 1463
product: InfluxDB Cloud Dedicated
version: cloud-dedicated
---

# View InfluxQL functions

Use InfluxQL functions to aggregate, select, transform, analyze, and predict data.

#### Missing InfluxQL functions

Some InfluxQL functions are in the process of being rearchitected to work with the InfluxDB 3 storage engine. If a function you need is not here, check the [InfluxQL feature support page](/influxdb3/cloud-dedicated/reference/influxql/feature-support/#function-support) for more information.

## InfluxQL functions (by type)

-   [Aggregates](/influxdb3/cloud-dedicated/reference/influxql/functions/aggregates/)
    -   [COUNT()](/influxdb3/cloud-dedicated/reference/influxql/functions/aggregates/#count)
    -   [DISTINCT()](/influxdb3/cloud-dedicated/reference/influxql/functions/aggregates/#distinct)
    -   [MEAN()](/influxdb3/cloud-dedicated/reference/influxql/functions/aggregates/#mean)
    -   [MEDIAN()](/influxdb3/cloud-dedicated/reference/influxql/functions/aggregates/#median)
    -   [MODE()](/influxdb3/cloud-dedicated/reference/influxql/functions/aggregates/#mode)
    -   [SPREAD()](/influxdb3/cloud-dedicated/reference/influxql/functions/aggregates/#spread)
    -   [STDDEV()](/influxdb3/cloud-dedicated/reference/influxql/functions/aggregates/#stddev)
    -   [SUM()](/influxdb3/cloud-dedicated/reference/influxql/functions/aggregates/#sum)
-   [Selectors](/influxdb3/cloud-dedicated/reference/influxql/functions/selectors/)
    -   [BOTTOM()](/influxdb3/cloud-dedicated/reference/influxql/functions/selectors/#bottom)
    -   [FIRST()](/influxdb3/cloud-dedicated/reference/influxql/functions/selectors/#first)
    -   [LAST()](/influxdb3/cloud-dedicated/reference/influxql/functions/selectors/#last)
    -   [MAX()](/influxdb3/cloud-dedicated/reference/influxql/functions/selectors/#max)
    -   [MIN()](/influxdb3/cloud-dedicated/reference/influxql/functions/selectors/#min)
    -   [PERCENTILE()](/influxdb3/cloud-dedicated/reference/influxql/functions/selectors/#percentile)
    -   [TOP()](/influxdb3/cloud-dedicated/reference/influxql/functions/selectors/#top)
-   [Transformations](/influxdb3/cloud-dedicated/reference/influxql/functions/transformations/)
    -   [ABS()](/influxdb3/cloud-dedicated/reference/influxql/functions/transformations/#abs)
    -   [ACOS()](/influxdb3/cloud-dedicated/reference/influxql/functions/transformations/#acos)
    -   [ASIN()](/influxdb3/cloud-dedicated/reference/influxql/functions/transformations/#asin)
    -   [ATAN()](/influxdb3/cloud-dedicated/reference/influxql/functions/transformations/#atan)
    -   [ATAN2()](/influxdb3/cloud-dedicated/reference/influxql/functions/transformations/#atan2)
    -   [CEIL()](/influxdb3/cloud-dedicated/reference/influxql/functions/transformations/#ceil)
    -   [COS()](/influxdb3/cloud-dedicated/reference/influxql/functions/transformations/#cos)
    -   [CUMULATIVE\_SUM()](/influxdb3/cloud-dedicated/reference/influxql/functions/transformations/#cumulative_sum)
    -   [DERIVATIVE()](/influxdb3/cloud-dedicated/reference/influxql/functions/transformations/#derivative)
    -   [DIFFERENCE()](/influxdb3/cloud-dedicated/reference/influxql/functions/transformations/#difference)
    -   [EXP()](/influxdb3/cloud-dedicated/reference/influxql/functions/transformations/#exp)
    -   [FLOOR()](/influxdb3/cloud-dedicated/reference/influxql/functions/transformations/#floor)
    -   [HISTOGRAM()](/influxdb3/cloud-dedicated/reference/influxql/functions/transformations/#histogram)
    -   [LN()](/influxdb3/cloud-dedicated/reference/influxql/functions/transformations/#ln)
    -   [LOG()](/influxdb3/cloud-dedicated/reference/influxql/functions/transformations/#log)
    -   [LOG2()](/influxdb3/cloud-dedicated/reference/influxql/functions/transformations/#log2)
    -   [LOG10()](/influxdb3/cloud-dedicated/reference/influxql/functions/transformations/#log10)
    -   [MOVING\_AVERAGE()](/influxdb3/cloud-dedicated/reference/influxql/functions/transformations/#moving_average)
    -   [NON\_NEGATIVE\_DERIVATIVE()](/influxdb3/cloud-dedicated/reference/influxql/functions/transformations/#non_negative_derivative)
    -   [NON\_NEGATIVE\_DIFFERENCE()](/influxdb3/cloud-dedicated/reference/influxql/functions/transformations/#non_negative_difference)
    -   [POW()](/influxdb3/cloud-dedicated/reference/influxql/functions/transformations/#pow)
    -   [ROUND()](/influxdb3/cloud-dedicated/reference/influxql/functions/transformations/#round)
    -   [SIN()](/influxdb3/cloud-dedicated/reference/influxql/functions/transformations/#sin)
    -   [SQRT()](/influxdb3/cloud-dedicated/reference/influxql/functions/transformations/#sqrt)
    -   [TAN()](/influxdb3/cloud-dedicated/reference/influxql/functions/transformations/#tan)
-   [Date and time](/influxdb3/cloud-dedicated/reference/influxql/functions/date-time/)
    -   [now()](/influxdb3/cloud-dedicated/reference/influxql/functions/date-time/#now)
    -   [time()](/influxdb3/cloud-dedicated/reference/influxql/functions/date-time/#time)
-   [Miscellaneous](/influxdb3/cloud-dedicated/reference/influxql/functions/misc/)
    -   [fill()](/influxdb3/cloud-dedicated/reference/influxql/functions/misc/#fill)