Skip to content

Tag Archives: postgreSQL-aggregate-functions

PostgreSQL provides with a SUM() function that is used to get the addition of values of a numeric column. Syntax: SUM(column) The following points needs… Read More
PostgreSQL MIN() function is an aggregate function that returns the minimum value in a set of values. Syntax: MIN(expression); The MIN() function can be used… Read More
PostgreSQL MAX() function is an aggregate function that returns the maximum value in a set of values. Syntax: MAX(expression); The MAX() function can be used… Read More
The STRING_AGG() function in PostgreSQL is an aggregate function that is used to concatenate a list of strings and place a separator between them. Syntax:… Read More
The COUNT() function is an aggregate function that enables users to get the number of rows that match a particular requirement of a query. Depending… Read More
PostgreSQL provides an AVG() function to calculate the average value of a set. The AVG() function is one of the most frequently used aggregate functions… Read More
PostgreSQL ARRAY_AGG() function is an aggregate function that accepts a set of values and returns an array where each value in the input set is… Read More