New posts in aggregate-functions

Optimal way to concatenate/aggregate strings

Return rows matching elements of input array in plpgsql function

Return as array of JSON objects in SQL (Postgres)

Postgres SQL - How do I aggregated groups of multiple consecutive rows?

Naming returned columns in Pandas aggregate function? [duplicate]

How to include "zero" / "0" results in COUNT aggregate?

MySQL "Group By" and "Order By"

Selecting a Record With MAX Value

Concatenate multiple result rows of one column into one, group by another column [duplicate]

Create a pivot table with PostgreSQL

The SQL OVER() clause - when and why is it useful?

How to define and use a User-Defined Aggregate Function in Spark SQL?

Spark SQL replacement for MySQL's GROUP_CONCAT aggregate function

LISTAGG in Oracle to return distinct values

PostgreSQL: running count of rows for a query 'by minute'

Spark SQL: apply aggregate functions to a list of columns

Does T-SQL have an aggregate function to concatenate strings? [duplicate]

Two SQL LEFT JOINS produce incorrect result

Postgres get multiple rows into a single json object

must appear in the GROUP BY clause or be used in an aggregate function