---
title: View InfluxQL functions
description: Aggregate, select, transform, and predict data with InfluxQL functions.
url: https://docs.influxdata.com/influxdb/v2/query-data/influxql/functions/
estimated_tokens: 1477
product: InfluxDB OSS v2
version: v2
publisher: InfluxData
canonical: https://docs.influxdata.com/influxdb/v2/query-data/influxql/functions/
date: '2025-04-02T15:54:32-06:00'
lastmod: '2025-04-02T15:54:32-06:00'
---

This page documents an earlier version of InfluxDB OSS.[InfluxDB 3 Core](/influxdb3/core/) is the latest stable version.

#### API token hashing is enabled by default in InfluxDB OSS 2.9.0

Stronger token security: tokens are stored as hashes on disk, so a
copy of the database file doesn’t expose usable tokens. Existing
tokens are hashed on first startup and the original strings can’t
be recovered afterward — **capture any plaintext tokens you still
need before you upgrade**.

For more information, see [Token hashing](/influxdb/v2/admin/tokens/#token-hashing).

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

> [!Note]
> To query with InfluxQL, the bucket you query must be mapped to a database and retention policy (DBRP). For more information, see how to [Query data with InfluxQL](/influxdb/v2/query-data/influxql/).

## InfluxQL functions (by type)

* [Aggregates](/influxdb/v2/query-data/influxql/functions/aggregates/)
  * [COUNT()](/influxdb/v2/query-data/influxql/functions/aggregates/#count)
  * [DISTINCT()](/influxdb/v2/query-data/influxql/functions/aggregates/#distinct)
  * [INTEGRAL()](/influxdb/v2/query-data/influxql/functions/aggregates/#integral)
  * [MEAN()](/influxdb/v2/query-data/influxql/functions/aggregates/#mean)
  * [MEDIAN()](/influxdb/v2/query-data/influxql/functions/aggregates/#median)
  * [MODE()](/influxdb/v2/query-data/influxql/functions/aggregates/#mode)
  * [SPREAD()](/influxdb/v2/query-data/influxql/functions/aggregates/#spread)
  * [STDDEV()](/influxdb/v2/query-data/influxql/functions/aggregates/#stddev)
  * [SUM()](/influxdb/v2/query-data/influxql/functions/aggregates/#sum)

* [Selectors](/influxdb/v2/query-data/influxql/functions/selectors/)
  * [BOTTOM()](/influxdb/v2/query-data/influxql/functions/selectors/#bottom)
  * [FIRST()](/influxdb/v2/query-data/influxql/functions/selectors/#first)
  * [LAST()](/influxdb/v2/query-data/influxql/functions/selectors/#last)
  * [MAX()](/influxdb/v2/query-data/influxql/functions/selectors/#max)
  * [MIN()](/influxdb/v2/query-data/influxql/functions/selectors/#min)
  * [PERCENTILE()](/influxdb/v2/query-data/influxql/functions/selectors/#percentile)
  * [SAMPLE()](/influxdb/v2/query-data/influxql/functions/selectors/#sample)
  * [TOP()](/influxdb/v2/query-data/influxql/functions/selectors/#top)

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

* [Technical analysis](/influxdb/v2/query-data/influxql/functions/technical-analysis/)
  * (Predictive analysis) [HOLT\_WINTERS()](/influxdb/v2/query-data/influxql/functions/technical-analysis/#holt_winters)
  * [CHANDE\_MOMENTUM\_OSCILLATOR()](/influxdb/v2/query-data/influxql/functions/technical-analysis/#chande_momentum_oscillator)
  * [EXPONENTIAL\_MOVING\_AVERAGE()](/influxdb/v2/query-data/influxql/functions/technical-analysis/#exponential_moving_average)
  * [DOUBLE\_EXPONENTIAL\_MOVING\_AVERAGE()](/influxdb/v2/query-data/influxql/functions/technical-analysis/#double_exponential_moving_average)
  * [KAUFMANS\_EFFICIENCY\_RATIO()](/influxdb/v2/query-data/influxql/functions/technical-analysis/#kaufmans_adaptive_moving_average)
  * [KAUFMANS\_ADAPTIVE\_MOVING\_AVERAGE()](/influxdb/v2/query-data/influxql/functions/technical-analysis/#kaufmans_adaptive_moving_average)
  * [TRIPLE\_EXPONENTIAL\_MOVING\_AVERAGE()](/influxdb/v2/query-data/influxql/functions/technical-analysis/#triple_exponential_moving_average)
  * [TRIPLE\_EXPONENTIAL\_DERIVATIVE()](/influxdb/v2/query-data/influxql/functions/technical-analysis/#triple_exponential_derivative)
  * [RELATIVE\_STRENGTH\_INDEX()](/influxdb/v2/query-data/influxql/functions/technical-analysis/#relative_strength_index)