Question : I have 3 tables, vendors, vendor_modelsand cameras. I am trying to get some values from db all of […]
Tag: aggregate
Use values from one column as column names and sum data from another table
Question : I’m going to do my best to describe this. So I have 3 tables as follows: project id […]
MongoDB aggregate performance compared to Postgres
Question : I have collection with about 700,000 documents. These documents represent locations in a hex grid. There are only […]
Getting duplicate results in many to many query
Question : I have designed a bookstore app with these tables. There’s a book with an M2M relation to author. […]
HAVING ANY in Postgres
Question : I’m looking for the right syntax to filter groups (i.e. groups of rows that have been GROUP BY‘d) […]
I want to perform max and sum aggregate on same column for different where clause in SQL server [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Get Aggregate Totals
Question : This query was already developed and produces line by line totals, then is copy/pasted into Excel to get […]
Add aggregated value filtered by a condition to existing query
Question : I have this table to collect data from IoT device: CREATE TABLE public.conferimenti ( id bigint NOT NULL […]
How to query chart data in a database agnostic way?
Question : I have several tables with data like this: +———————+—————+ | Creation Timestamp | Numeric Value | +———————+—————+ | […]
Postgres group and aggregate(sum) JSONb arrays and non JSONb properties
Question : Version PostgreSQL 11.7 on x86_64-pc-linux-gnu, compiled by gcc, a 224fe214a p 3971489d3e, 64-bit I am trying to build […]