Discover published sets by community

Explore tens of thousands of sets crafted by our community.

SQL Aggregate Functions

Flashcards

0/10

Still learning

STRING_AGG()

Aggregates string values within a group with a specified separator. Syntax: STRING_AGG(expression, separator)

COUNT()

Counts the number of rows that match a specified criteria. Syntax: COUNT(expression)

SUM()

Calculates the sum of a set of values or expression. Syntax: SUM(column_name)

STDDEV()

Calculates the standard deviation of a set of values. Syntax: STDDEV(column_name)

MIN()

Finds the minimum value in a set. Syntax: MIN(column_name)

GROUP_CONCAT()

Concatenates values from multiple rows. Syntax: GROUP_CONCAT(column_name SEPARATOR 'separator')

VAR_POP()

Computes the population variance of a set of values. Syntax: VAR_POP(column_name)

AVG()

Determines the average value of a numeric column. Syntax: AVG(column_name)

MAX()

Finds the maximum value in a set. Syntax: MAX(column_name)

ARRAY_AGG()

Aggregates values as an array. Syntax: ARRAY_AGG(expression)

Know

Still learning

Click to flip

Know