Tag: aggregate

Found 330 results for 'aggregate'.

---

1) postgresql - WHERE clause not preventing return of row but changing values for aggregate function (here: count)
2) postgresql - Postgres group and aggregate(sum) JSONb arrays and non JSONb properties
3) postgresql - Aggregate objects into a json array (subquery issues)
4) postgresql - Why is array_agg() slower than the non-aggregate ARRAY() constructor?
5) postgresql - Postgresql: Pattern match against array elements?
6) postgresql - How to select multiple values into an array and loop through? (postgres 9.3)
7) postgresql - Select into specific array positions with array_agg()?
8) postgresql - Is there Hypothetical-Set Aggregate Function equivalent to `ntile` in Postgres?
9) postgresql - Time-series window query for calculating rolling average across group by subquery is inaccurate due to missing rows
10) postgresql - Query to obtain weighted percentile
11) sql-server - Is it possible to make a reference to the result of an aggregate function in a SELECT clause from the same SELECT clause?
12) postgresql - Using Select Alias in where clause
13) sql-server - SELECT minimum value without a subquery
14) azure-sql-database - Column 'Comments.Text' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause
15) postgresql - Rolling sum / count / average over date interval
16) sql-server - Why does COUNT() aggregate return 0 for 'NULL'?
17) postgresql - Interval values for aggregate function AVG greater than 24 hours
18) postgresql - Group and count array elements using intarray
19) postgresql - How to apply ORDER BY and LIMIT in combination with an aggregate function?
20) postgresql - Merging one-to-many and one-to-one relation in the same JSON object in postgresql
21) postgresql - Percentile rank that takes sorted argument (or same functionality) in PostgreSQL 9.3.5
22) postgresql - Create smaller row from alias and preserve column names
23) postgresql - HAVING ANY in Postgres
24) postgresql - Convert right side of join of many to many into array
25) postgresql - How can I match the items in an array column, with a different table in Postgres?
26) postgresql - Find most frequent values for a given column
27) postgresql - Get maximum from aggregated values in a query
28) postgresql - Return total number of rows and selected (aggregated) data
29) postgresql - merge json online postgresql 10
30) postgresql - Aggregate query with min
31) postgresql - Accumulate values into an array with Postgres
32) postgresql - Aggregate rows of type array
33) mysql - ORDER BY on aggregate field on a closure table giving unexpected results
34) postgresql - Select data based on records created_at column
35) postgresql - SUM over distinct rows with multiple joins
36) join - Access (Jet) SQL: DateTime stamps in TableB flanking each DateTime stamp in TableA
37) oracle - How to create index to improve performance of an aggregate function that creates a table in oracle
38) postgresql - Postgres Nested WHEN Aggregate Function
39) postgresql - Understanding multiple table join with aggregation
40) postgresql - CTE clause not able to be used in final ORDER BY statement
41) mysql - Median with GROUP BY
42) sql-server - Group by multiple columns, agregate others and select all in SQL Server
43) mysql - Total hours worked per employee per day including overnight sessions
44) postgresql - Nested aggregate functions over different dimensions
45) postgresql - Aggregate rows for each group of rows
46) oracle - GROUP BY with weighted average
47) postgresql - Multiple aggregates with cross (lateral) join
48) group-by - How to enforce strict handling of GROUP BY with non-aggregate / bare columns or UPDATE with multiple-row SELECT in SQLite
49) sql-server - SQL-Server: What is a good way to aggregate on different columns within the same query?
50) postgresql - SUM() the result of a function

---