New posts in aggregate-functions

Grouped string aggregation / LISTAGG for SQL Server

Get average time difference between current and previous row

Why can't you mix Aggregate values and Non-Aggregate values in a single SELECT?

LINQ aggregate and group by periods of time

string aggregation in Cypher

Count cumulative total in Postgresql

use mysql SUM() in a WHERE clause

How to avoid error "aggregate functions are not allowed in WHERE"

How to sum data.frame column values?

How to fetch the first and last record of a grouped record in a MySQL query with aggregate functions?

Get the distinct sum of a joined table column

SQL Query to get column values that correspond with MAX value of another column?

How to define a custom aggregation function to sum a column of Vectors?

GROUP BY without aggregate function

Selecting data into a Postgres array

Postgres window function and group by exception

GROUP BY + CASE statement

Best way to count rows by arbitrary time intervals

Avoid division by zero in PostgreSQL

Aggregate function in MySQL - list (like LISTAGG in Oracle)