List Question
20 TechQA 2023-11-23T18:39:52.950000SQL (standard) join count by several columns
127 views
Asked by James Ostevik
Getting an [null] response from SQL query using json_agg
658 views
Asked by Jake
Get conditional count and conditional DISTINCT count in a single SELECT
424 views
Asked by user3842536
How to us CASE WHEN aggregation with bookshelf
283 views
Asked by Adrien DEBLOCK
Mapping array to composite type to a different row type
180 views
Asked by Willem D'Haeseleer
Conditional aggregate queries
139 views
Asked by Gwillis
Conditional count of rows where at least one peer qualifies
117 views
Asked by logjammin
Create a report with 2 rows of values, each of which is from a separate SELECT statement
73 views
Asked by iconoclast
Combine two queries to count distinct strings with different filters
350 views
Asked by Martin
Sum of alias columns in PostgreSQL
646 views
Asked by krickX
Logstash Aggregate filter plugin Not working properly
651 views
Asked by Benson
Get total count and filtered count from single subquery
729 views
Asked by Omar khaled
How to find the average of a subset of values from a table in PostgreSQL?
572 views
Asked by user2990406
Count devices per day in a given date range
504 views
Asked by Ash
logstash crashes with "NoMethodError: undefined method `multi_filter' for nil:NilClass"
1.2k views
Asked by Armin Abfalterer
aggregate logstash filter with "multiple pipelines"
582 views
Asked by Armin Abfalterer
Counting the number of repeating customer and new customer for every month in sql
473 views
Asked by Nur Atiqah
Aggregate the same column in multiple different ways
1.2k views
Asked by Cole
Pivot table without crosstab/tablefunc
10.3k views
Asked by sm1994
Postgres COUNT number of column values with INNER JOIN
2.9k views
Asked by jackhammer013