Tag: group-by

PostgreSQL json_build_object nested

group-by json postgresql postgresql-11 sql

First things first: I’m using PostgreSQL 11.6, compiled by Visual C++ build 1800, 64-bit. 🙂 Im trying to create a JSON object directly from the database. My desired result is { “1”: [], “…

Is there anybody who can help me with mysql query?

group-by mysql pivot sql sum

SELECT (SELECT SUM(kwh) FROM energy_logger WHERE TIME >= ’05:30:00′ AND TIME = ’18:30:00′ AND …

How to add a column of total number of rows in BigQuery

count date google-bigquery group-by sql

I have a table in BigQuery where I save a DATESTAMP and temperature sensor value. I usually filter the query by dates. My goal is to add a column in this query where it puts the total number of rows. For example, if I run this query I have this result: And when I run this query I have this

How to flatten Rows into Column (Field) Values

group-by sql

I have data that has Job_ids split across multiple rows (i’ve had to do this because previously i’ve had to split out team members from each job_id, then identify their teams The format my data is currently in is as follows, (not shown) but each job_id has an employee who has a team assigment, and therefore for each row there

How to divide with each other the two queries with different conditions?

group-by pivot postgresql sql

There is a table in which the managers column and the status column. How to calculate the total status of Fully, the divided total of records with all statuses except N / A for each manager? I tried to portray in this way, but nothing came of it First Query Second Query Need to recieve two columns with name and

SQL order with equal group size

group-by limit sql sql-order-by

I have a table with columns month, name and transaction_id. I would like to count the number of transactions per month and name. However, for each month I want to have the top N names with the highest …

Group by using linked tables

group-by sql sql-server

I have linked tables. Calls and Call Lines, both tables have a seperate ‘Call Type’ field, I am trying to get the number of calls and the number of call lines which were added on a certain date and then see the split for the types. The below query returns the number for each Call Line which was added, but

Posts navigation

Prev 1 … 29 30 31 … 42 Next