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/version/query-data/influxql/).
{{%/ note %}}

## InfluxQL functions (by type)

- [Aggregates](/influxdb/version/query-data/influxql/functions/aggregates/)
  - [COUNT()](/influxdb/version/query-data/influxql/functions/aggregates/#count)
  - [DISTINCT()](/influxdb/version/query-data/influxql/functions/aggregates/#distinct)
  - [INTEGRAL()](/influxdb/version/query-data/influxql/functions/aggregates/#integral)
  - [MEAN()](/influxdb/version/query-data/influxql/functions/aggregates/#mean)
  - [MEDIAN()](/influxdb/version/query-data/influxql/functions/aggregates/#median)
  - [MODE()](/influxdb/version/query-data/influxql/functions/aggregates/#mode)
  - [SPREAD()](/influxdb/version/query-data/influxql/functions/aggregates/#spread)
  - [STDDEV()](/influxdb/version/query-data/influxql/functions/aggregates/#stddev)
  - [SUM()](/influxdb/version/query-data/influxql/functions/aggregates/#sum)
- [Selectors](/influxdb/version/query-data/influxql/functions/selectors/)
  - [BOTTOM()](/influxdb/version/query-data/influxql/functions/selectors/#bottom)
  - [FIRST()](/influxdb/version/query-data/influxql/functions/selectors/#first)
  - [LAST()](/influxdb/version/query-data/influxql/functions/selectors/#last)
  - [MAX()](/influxdb/version/query-data/influxql/functions/selectors/#max)
  - [MIN()](/influxdb/version/query-data/influxql/functions/selectors/#min)
  - [PERCENTILE()](/influxdb/version/query-data/influxql/functions/selectors/#percentile)
  - [SAMPLE()](/influxdb/version/query-data/influxql/functions/selectors/#sample)
  - [TOP()](/influxdb/version/query-data/influxql/functions/selectors/#top)
- [Transformations](/influxdb/version/query-data/influxql/functions/transformations/)
  - [ABS()](/influxdb/version/query-data/influxql/functions/transformations/#abs)
  - [ACOS()](/influxdb/version/query-data/influxql/functions/transformations/#acos)
  - [ASIN()](/influxdb/version/query-data/influxql/functions/transformations/#asin)
  - [ATAN()](/influxdb/version/query-data/influxql/functions/transformations/#atan)
  - [ATAN2()](/influxdb/version/query-data/influxql/functions/transformations/#atan2)
  - [CEIL()](/influxdb/version/query-data/influxql/functions/transformations/#ceil)
  - [COS()](/influxdb/version/query-data/influxql/functions/transformations/#cos)
  - [CUMULATIVE_SUM()](/influxdb/version/query-data/influxql/functions/transformations/#cumulative_sum)
  - [DERIVATIVE()](/influxdb/version/query-data/influxql/functions/transformations/#derivative)
  - [DIFFERENCE()](/influxdb/version/query-data/influxql/functions/transformations/#difference)
  - [ELAPSED()](/influxdb/version/query-data/influxql/functions/transformations/#elapsed)
  - [EXP()](/influxdb/version/query-data/influxql/functions/transformations/#exp)
  - [FLOOR()](/influxdb/version/query-data/influxql/functions/transformations/#floor)
  - [HISTOGRAM()](/influxdb/version/query-data/influxql/functions/transformations/#histogram)
  - [LN()](/influxdb/version/query-data/influxql/functions/transformations/#ln)
  - [LOG()](/influxdb/version/query-data/influxql/functions/transformations/#log)
  - [LOG2()](/influxdb/version/query-data/influxql/functions/transformations/#log2)
  - [LOG10()](/influxdb/version/query-data/influxql/functions/transformations/#log10)
  - [MOVING_AVERAGE()](/influxdb/version/query-data/influxql/functions/transformations/#moving_average)
  - [NON_NEGATIVE_DERIVATIVE()](/influxdb/version/query-data/influxql/functions/transformations/#non_negative_derivative)
  - [NON_NEGATIVE_DIFFERENCE()](/influxdb/version/query-data/influxql/functions/transformations/#non_negative_difference)
  - [POW()](/influxdb/version/query-data/influxql/functions/transformations/#pow)
  - [ROUND()](/influxdb/version/query-data/influxql/functions/transformations/#round)
  - [SIN()](/influxdb/version/query-data/influxql/functions/transformations/#sin)
  - [SQRT()](/influxdb/version/query-data/influxql/functions/transformations/#sqrt)
  - [TAN()](/influxdb/version/query-data/influxql/functions/transformations/#tan)
- [Technical analysis](/influxdb/version/query-data/influxql/functions/technical-analysis/)
  - (Predictive analysis) [HOLT_WINTERS()](/influxdb/version/query-data/influxql/functions/technical-analysis/#holt_winters)
  - [CHANDE_MOMENTUM_OSCILLATOR()](/influxdb/version/query-data/influxql/functions/technical-analysis/#chande_momentum_oscillator)
  - [EXPONENTIAL_MOVING_AVERAGE()](/influxdb/version/query-data/influxql/functions/technical-analysis/#exponential_moving_average)
  - [DOUBLE_EXPONENTIAL_MOVING_AVERAGE()](/influxdb/version/query-data/influxql/functions/technical-analysis/#double_exponential_moving_average)
  - [KAUFMANS_EFFICIENCY_RATIO()](/influxdb/version/query-data/influxql/functions/technical-analysis/#kaufmans_adaptive_moving_average)
  - [KAUFMANS_ADAPTIVE_MOVING_AVERAGE()](/influxdb/version/query-data/influxql/functions/technical-analysis/#kaufmans_adaptive_moving_average)
  - [TRIPLE_EXPONENTIAL_MOVING_AVERAGE()](/influxdb/version/query-data/influxql/functions/technical-analysis/#triple_exponential_moving_average)
  - [TRIPLE_EXPONENTIAL_DERIVATIVE()](/influxdb/version/query-data/influxql/functions/technical-analysis/#triple_exponential_derivative)
  - [RELATIVE_STRENGTH_INDEX()](/influxdb/version/query-data/influxql/functions/technical-analysis/#relative_strength_index)