Help Center/ SecMaster/ User Guide/ Threat Operations/ Query and Analysis Syntax - V2/ Retrieval SQL Syntax Reference/ Analysis Statements/ Aggregate Functions
Updated on 2024-11-11 GMT+08:00
View PDF
Share

Aggregate Functions

Table 1 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
Parent topic: Analysis Statements