Help Center/ SecMaster/ User Guide (ME-Abu Dhabi Region)/ Threat Operations/ Security Analysis/ Query and Analysis Statements - SQL Syntax/ Analysis Statements - Aggregate Functions
Updated on 2024-07-18 GMT+08:00
View PDF
Share

Analysis Statements - 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