Search code examples
Complex point aggregation with modifiers...


sqlpostgresqlaggregate-functions

Read More
MongoDB: Map array of ids to objects while preserving order via aggregation functions...


mongodbmongodb-queryaggregation-frameworkpymongoaggregate-functions

Read More
Given time/interval to calculate open/high/low/close value in each grouped data...


sqlpostgresqlaggregate-functionswindow-functions

Read More
Max() and Min() have different behaviours?...


sql-servert-sqlmaxaggregate-functionsmin

Read More
Nested grouping in MongoDB aggregation...


mongodbmongodb-queryaggregation-frameworkpymongoaggregate-functions

Read More
Determine a target record's offset in a Postgres query...


sqljsonpostgresqlpaginationaggregate-functions

Read More
Aggregate function in Tuple Relational Calculus...


sqldatabaserelational-databaseaggregate-functionstuple-relational-calculus

Read More
compare an attribute value to the value of an aggregate function in relational algebra...


aggregate-functionsrelational-algebra

Read More
SQL select only rows with max value on a column...


mysqlsqlaggregate-functionsgreatest-n-per-groupgroupwise-maximum

Read More
MySQL "Group By" and "Order By"...


mysqlsqlgroup-bysql-order-byaggregate-functions

Read More
Create two arrays for two fields, keeping sort order of arrays in sync (without subquery)...


sqlarrayspostgresqlsortingaggregate-functions

Read More
Concatenate date values in Postgres...


sqlpostgresqlaggregate-functions

Read More
aggregating MAX() over a group over the MAX() of a subgroup...


sqlsql-serveraggregate-functions

Read More
Why the order by in XMLAGG doesn't give the same result as the same order by on a SELECT?...


sqlxmloracleaggregate-functionsoracle19c

Read More
PostgreSQL - string_agg with limited number of elements...


sqlpostgresqlaggregate-functions

Read More
building a trigger function to process json data with postgres...


jsonpostgresqltriggersaggregate-functionsplpgsql

Read More
Why does one aggregate query work and the other raise an error?...


postgresqlaggregate-functions

Read More
Postgres: limit by the results of a sum function...


sqlpostgresqlaggregate-functionsplpgsqlcommon-table-expression

Read More
Aggregated rollup in PostgreSQL with avg and sum in different levels?...


sqldatabasepostgresqlgroup-byaggregate-functions

Read More
Does T-SQL have an aggregate function to concatenate strings?...


sql-serversql-server-2005t-sqlgroup-byaggregate-functions

Read More
Oracle SQL - Sum and group data by week...


sqloracleaggregate-functions

Read More
What is the difference between PARTITION BY and GROUP BY...


sqlaggregate-functionswindow-functions

Read More
MySQL ask to add column to GROUP BY which I don't want to use in GROUP BY...


sqlmysqlgroup-byaggregate-functionsmysql-5.7

Read More
PostgreSQL, SUM and GROUP from numeric column and hstore...


postgresqlaggregate-functionshstore

Read More
How to use a SQL window function to calculate a percentage of an aggregate...


sqlpostgresqlaggregate-functionswindow-functionsgreenplum

Read More
Need to format the data in trino sql...


sqlaggregate-functionsprestotrino

Read More
Column names in GROUP BY and ORDER BY...


sqlpostgresqlgroup-bycaseaggregate-functions

Read More
SQL filter rows by range overlap...


sqlsnowflake-cloud-data-platformaggregate-functionswindow-functions

Read More
how to calculate the amount?...


postgresqlaggregate-functions

Read More
Convert a query result to hstore...


postgresqlaggregate-functionshstore

Read More
BackNext