Help Center> SecMaster> User Guide (ME-Abu Dhabi Region)> Threat Operations> Security Analysis> Query and Analysis Syntax> SQL Syntax> Analysis Statements> Aggregate Functions
Updated on 2023-10-31 GMT+08:00
View PDF

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