Need to retrieve a column from a group-by query, and this column is not part of the group-by clause. I have a table that receives telemetries from equipments: COLUMNS: transmission_tag varchar -- this is kind of a transmission package identifier…
I have following example: create table products (name text, id integer, type smallint, category integer); insert into products values ('apple', 23, 1, 1200), ('apple', 23, 1, 999), ('apple', 31, 2, 1200), ('apple', 23, 3, 1200), ('orange', 10, 1, 200), ('orange',…
The dataset is like this: g1 = {d1,d3,d5} g2 = {d1,d3,d2} g3 = {d4,d3,d5} I have the following table called director_genre: director_id | genre d1 g1 d1 g2 d2 g2 d3 g1 d3 g2 d3 g3 d4 g3 d5 g1…
I have many records in the table. I was grouped by continuous date. example : begin_at (From Date) end_at (to date) 2023-05-05 00:00:00 2023-06-18 00:00:00 2023-06-11 00:00:00 2023-06-18 00:00:00 2023-06-12 00:00:00 2023-06-18 00:00:00 2023-06-13 00:00:00 2023-06-18 00:00:00 2023-06-14 00:00:00 2023-06-18…
I have a query for deployment table. There is no data for hotfix column now. I want to show all change count without hotfix and with hotfix for time intervals. Table data: deployTime changeno hotfix 2022-08 aaa 2022-08 bbb 2022-11…
I have 2 different date fields, 1 when the case was created and the other when the case completed. I am trying to count total cases and total completions in say 2023. Whenever I run my query and set the…
I have a table like below: id device_id device_model 1 101 A 1 201 B 1 202 B 2 102 A 2 301 C 3 103 A 3 203 B 3 302 C I want to select group of ids…
Get a column with total sale by each agent and second column with total sale for company as well in each row I have 3 tables, queries added below for table schemas and data. I want to get total sales…
I want to generate report in phpmysql in such a way that first detail rows display and in the bottom , sum of that detail row display on the basis of group by statement. Select id, Emp-name, department, salary, sum(salary)…
Let's say we have a table called 'grouper' id column_a 1 value 2 value And a table called 'translation' that contains following columns id locale text grouper_id 1 en some en text 1 2 es some es text 1 3…