DDSQL Aggregation Functions
このページは日本語には対応しておりません。随時翻訳に取り組んでいます。翻訳に関してご質問やご意見ございましたら、お気軽にご連絡ください。
Aggregation functions
Aggregate functions compute a single result from a set of input values, usually used in conjunction with a GROUP BY statement.
avg
| Name | Argument Types | Return type | Description |
|---|
| avg(expr e) | numeric | numeric | Computes the average (arithmetic mean) of all the non-null input values. |
max
| Name | Argument Types | Return type | Description |
|---|
| max(expr e) | variable | variable | Computes the maximum of the non-null input values. Types of input values must be comparable. |
min
| Name | Argument Types | Return type | Description |
|---|
| min(expr e) | variable | variable | Computes the minimum of the non-null input values. Types of input values must be comparable. |
sum
| Name | Argument Types | Return type | Description |
|---|
| sum(expr e) | numeric | numeric | Computes the sum of the non-null input values. |
count
| Name | Argument Types | Return type | Description |
|---|
| count(expr e) | numeric | integer | Computes the number of input rows in which the input value is not null. |
| count(distinct expr e1, e2 …) | | integer | Computes the number of input values in which the input value is not null. |
| count(*) | | integer | Computes the number of input rows. |
string_agg
| Name | Argument Types | Return type | Description |
|---|
| string_agg(expr e, delimiter e) | string, string | string | Concatenates the input values, seperated by a delimiter. |
array_agg
| Name | Argument Types | Return type | Description |
|---|
| string_agg(expr e) | variable | array | Concatenates the input values into an array. |
