Aggregate Functions
Function |
Purpose |
Description |
Example Value |
---|---|---|---|
avg |
Average value |
avg(number T) -> T |
SELECT avg(age) LIMIT 1 |
sum |
Sum |
sum(number T) -> T |
SELECT sum(age) LIMIT 1 |
min |
Specifies the minimum value. |
min(number T) -> T |
SELECT min(age) LIMIT 1 |
max |
Maximum value |
max(number T) -> T |
SELECT max(age) LIMIT 1 |
count |
Occurrences |
count(field) -> integer , count(*) -> integer , count(1) -> integer |
SELECT count(age) LIMIT 1 , SELECT count(*) LIMIT 1 , SELECT count(1) LIMIT 1 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.