---
title: View InfluxQL functions
description: Aggregate, select, transform, and predict data with InfluxQL functions.
url: https://docs.influxdata.com/influxdb3/enterprise/reference/influxql/functions/
estimated_tokens: 1163
product: InfluxDB 3 Enterprise
version: enterprise
publisher: InfluxData
canonical: https://docs.influxdata.com/influxdb3/enterprise/reference/influxql/functions/
date: '2025-01-13T07:21:11-07:00'
lastmod: '2025-01-13T07:21:11-07:00'
---

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/enterprise/reference/influxql/feature-support/#function-support)for more information.

## InfluxQL functions (by type)

* [Aggregates](/influxdb3/enterprise/reference/influxql/functions/aggregates/)
  * [COUNT()](/influxdb3/enterprise/reference/influxql/functions/aggregates/#count)
  * [DISTINCT()](/influxdb3/enterprise/reference/influxql/functions/aggregates/#distinct)
  * [MEAN()](/influxdb3/enterprise/reference/influxql/functions/aggregates/#mean)
  * [MEDIAN()](/influxdb3/enterprise/reference/influxql/functions/aggregates/#median)
  * [MODE()](/influxdb3/enterprise/reference/influxql/functions/aggregates/#mode)
  * [SPREAD()](/influxdb3/enterprise/reference/influxql/functions/aggregates/#spread)
  * [STDDEV()](/influxdb3/enterprise/reference/influxql/functions/aggregates/#stddev)
  * [SUM()](/influxdb3/enterprise/reference/influxql/functions/aggregates/#sum)

* [Selectors](/influxdb3/enterprise/reference/influxql/functions/selectors/)
  * [BOTTOM()](/influxdb3/enterprise/reference/influxql/functions/selectors/#bottom)
  * [FIRST()](/influxdb3/enterprise/reference/influxql/functions/selectors/#first)
  * [LAST()](/influxdb3/enterprise/reference/influxql/functions/selectors/#last)
  * [MAX()](/influxdb3/enterprise/reference/influxql/functions/selectors/#max)
  * [MIN()](/influxdb3/enterprise/reference/influxql/functions/selectors/#min)
  * [PERCENTILE()](/influxdb3/enterprise/reference/influxql/functions/selectors/#percentile)
  * [TOP()](/influxdb3/enterprise/reference/influxql/functions/selectors/#top)

* [Transformations](/influxdb3/enterprise/reference/influxql/functions/transformations/)
  * [ABS()](/influxdb3/enterprise/reference/influxql/functions/transformations/#abs)
  * [ACOS()](/influxdb3/enterprise/reference/influxql/functions/transformations/#acos)
  * [ASIN()](/influxdb3/enterprise/reference/influxql/functions/transformations/#asin)
  * [ATAN()](/influxdb3/enterprise/reference/influxql/functions/transformations/#atan)
  * [ATAN2()](/influxdb3/enterprise/reference/influxql/functions/transformations/#atan2)
  * [CEIL()](/influxdb3/enterprise/reference/influxql/functions/transformations/#ceil)
  * [COS()](/influxdb3/enterprise/reference/influxql/functions/transformations/#cos)
  * [CUMULATIVE\_SUM()](/influxdb3/enterprise/reference/influxql/functions/transformations/#cumulative_sum)
  * [DERIVATIVE()](/influxdb3/enterprise/reference/influxql/functions/transformations/#derivative)
  * [DIFFERENCE()](/influxdb3/enterprise/reference/influxql/functions/transformations/#difference)
  * [EXP()](/influxdb3/enterprise/reference/influxql/functions/transformations/#exp)
  * [FLOOR()](/influxdb3/enterprise/reference/influxql/functions/transformations/#floor)
  * [HISTOGRAM()](/influxdb3/enterprise/reference/influxql/functions/transformations/#histogram)
  * [LN()](/influxdb3/enterprise/reference/influxql/functions/transformations/#ln)
  * [LOG()](/influxdb3/enterprise/reference/influxql/functions/transformations/#log)
  * [LOG2()](/influxdb3/enterprise/reference/influxql/functions/transformations/#log2)
  * [LOG10()](/influxdb3/enterprise/reference/influxql/functions/transformations/#log10)
  * [MOVING\_AVERAGE()](/influxdb3/enterprise/reference/influxql/functions/transformations/#moving_average)
  * [NON\_NEGATIVE\_DERIVATIVE()](/influxdb3/enterprise/reference/influxql/functions/transformations/#non_negative_derivative)
  * [NON\_NEGATIVE\_DIFFERENCE()](/influxdb3/enterprise/reference/influxql/functions/transformations/#non_negative_difference)
  * [POW()](/influxdb3/enterprise/reference/influxql/functions/transformations/#pow)
  * [ROUND()](/influxdb3/enterprise/reference/influxql/functions/transformations/#round)
  * [SIN()](/influxdb3/enterprise/reference/influxql/functions/transformations/#sin)
  * [SQRT()](/influxdb3/enterprise/reference/influxql/functions/transformations/#sqrt)
  * [TAN()](/influxdb3/enterprise/reference/influxql/functions/transformations/#tan)

* [Date and time](/influxdb3/enterprise/reference/influxql/functions/date-time/)
  * [now()](/influxdb3/enterprise/reference/influxql/functions/date-time/#now)
  * [time()](/influxdb3/enterprise/reference/influxql/functions/date-time/#time)

* [Miscellaneous](/influxdb3/enterprise/reference/influxql/functions/misc/)
  * [fill()](/influxdb3/enterprise/reference/influxql/functions/misc/#fill)