I need to collect data from different tables, without duplicates and with a column that collects the presence where I've found each item. So, this is my scenario: TABLEA itemId name 1 John 2 Sam TABLEB itemId name 1 John…
I have a union with a struct inside. When trying to compile on Linux, I get an error (or more like 50 of the same kind). The same code works in Visual Studio on Windows. main.c:772:43: error: ‘union data’ has…
I have a table which has only one row like below, Here I want to convert the column names to one column and the row into another column, with the column names converted to some predefined numbers as below (A->1E9,…
I'm using Laravel package staudenmeir/laravel-cte but am not able to articulate the query I want MY SQL query : WITH T AS ( SELECT Id, DeviceType, DeviceId, ENERGY_Total, `Time` FROM devices_sensor_data WHERE `Time` BETWEEN '2023-03-28 00:00:00' AND '2023-03-27 20:40:00' AND…
Building a social site which allows users to follow each other, and enforcing a business rule that only allows DMs when two users mutually follow each other. Follows are stored in a lookup: TABLE FOLLOWS - userA_ID FK - userB_ID…
I have 4 Tables : 1- Suppliers ID_A Supplier_name 1 Apple 2 Xiaomi 3 Nokia 4 Oppo 2- Start Balance ID_B Start Balance 1 1000 2 1000 3 1000 4 Null 3- Invoices ID_C Invoice_value 1 200 1 500 2…
So I have a table 'A' with has column of numerical values of 12 digits, now there is another table 'B' which has only first 6 digits of the same numerical value, I want to join both the tables using…
DB-Fiddle create table items ( name varchar(15) not null, id1 integer, id2 integer, UNIQUE(id1), UNIQUE(id2) ); insert into items (name, id1, id2) values ('a', 1, null), ('b', 2, null), ('c', null, 2); select * from items where id1=2 union select…
Can't come up with easy solution how to union tables with same columns but from second table add only rows which are present in first table. t1: id A B C 1 xx r g 2 cc r g 5…
I have 2 tables tableA: id dateA colA ... 1 2022-11-11 12:00:00 A 2 2022-11-12 12:00:00 B 3 2022-11-14 12:00:00 C tableB: id dateB colB ... 3 2022-11-05 12:00:00 D 4 2022-11-06 12:00:00 E 5 2022-11-13 12:00:00 F and I…