44 lines
1.1 KiB
Markdown
44 lines
1.1 KiB
Markdown
---
|
|
title: Aggregate data with SQL
|
|
description: >
|
|
Use aggregate and selector functions to perform aggregate operations on your
|
|
time series data.
|
|
menu:
|
|
influxdb3_enterprise:
|
|
name: Aggregate data
|
|
parent: Query with SQL
|
|
identifier: query-sql-aggregate
|
|
weight: 203
|
|
influxdb3/enterprise/tags: [query, sql]
|
|
related:
|
|
- /influxdb3/enterprise/reference/sql/functions/aggregate/
|
|
- /influxdb3/enterprise/reference/sql/functions/selector/
|
|
- /influxdb3/enterprise/reference/sql/group-by/
|
|
list_code_example: |
|
|
##### Aggregate fields by groups
|
|
```sql
|
|
SELECT
|
|
mean(field1) AS mean,
|
|
selector_first(field2)['value'] as first,
|
|
tag1
|
|
FROM home
|
|
GROUP BY tag
|
|
```
|
|
|
|
##### Aggregate by time-based intervals
|
|
```sql
|
|
SELECT
|
|
DATE_BIN(INTERVAL '1 hour', time, '2022-01-01T00:00:00Z'::TIMESTAMP) AS time,
|
|
mean(field1),
|
|
sum(field2),
|
|
tag1
|
|
FROM home
|
|
GROUP BY 1, tag1
|
|
```
|
|
source: /shared/influxdb3-query-guides/sql/aggregate-select.md
|
|
---
|
|
|
|
<!--
|
|
The content for this page is at content/shared/influxdb3-query-guides/sql/aggregate-select.md
|
|
-->
|