I have the following table - orders: id value price amount 2 'orange' $12 7 8 'yellow' $14 29 5 'green' $17 9 I have to perform SELECT query with WHERE IN clause SELECT value FROM order WHERE id IN…
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…