I have a my_table like this. Col2 is a string type: | Col1 | Col2 | |--------------|------------------------| | some_string |{key1:0, key2:1, key3:0}| | some_string |{key1:0, key2:0, key3:0}| | some_string |{key1:1, key2:2, key3:3}| | some_string |{key1:1, key2:1, key3:0}| I would like…
I am doing an upsert into say table1 with a composite primary key on col1, col3. I understand I can do it as insert into table1 (col1, col2, col3, col4) values (val1, val2, val3, val4) on conflict(col1, col3) do update…
I am trying to build a function to return the count of days past due where the customer was less than 3 days late. Using the dvdrental database provided by PostgreSQL. It seems as though it's returning 6 for every…
My task: The variables x and def are a counter and a boolean respectively. Both start at zero. If at any point in time x > 2 then def = 1 from that point onward. Now if def = 1…
I am trying to obtain all days to a month in my MySQL database. This query is being called in one of my Grafana dashboards that has a variable for the year, the month and the day. This query is…
I have two tables: dates: date 2024-01-01 2024-01-02 2024-01-03 2024-01-04 2024-01-05 actual: business_date id 2024-01-01 1 2024-01-02 2 2024-01-04 4 2024-01-05 5 I want to join these tables on the condition date = business_date, but in the case where there's…
I have a huge dataset on two tables (users, pos_transactions), and I need to execute a join on them. I wrote the query both with join and subquery approches. Both looks Non-optimal: explain SELECT pt.card_number FROM pos_transactions pt where user_id…
Existing Data { "Attr1": "AAAAAAAAA", "Attr2": 70, "Attr3": null, "Attr4": false } I want to insert in below format right after the Attr2 both exists "NewAttr": { "SourceTable1.Column1": "12xx12", "SourceTable2.Column2": "0192xx" } Column1 exists but not Column2 "NewAttr": { "SourceTable1.Column1":…
Got this question for a while and wondering if there is any faster query. I have a table with multiple entries per ID, and would like to list all columns with different values for the same ID. ID Brand Type…
is there any way to write query without subquery?. i have with: with test as ( select 1 as user_id, 'sadasdasggg1' as order_id, sysdate - 1 as order_date from dual union select 1, 'sadasdasggg2', sysdate - 2 from dual union…