master_table: _id zipcode 123 100 456 200 temp_table: _id zipcode 123 111 245 222 master_table (new results must be upserted in master_table) _id zipcode 123 111 456 200 my end goal is to insert records from temp_table to master_table and…
I have a database running in Microsoft Azure. I want to run a script in it. The problem is that the script only works if the SQL commands are run one at a time. So several commands are executed at…
When I tried to delete from a table with right join is working, when I added a LIMIT query fails : DELETE la FROM log_artim la RIGHT JOIN corm_artim ca ON la.idCorm = ca.id WHERE la.da <= '2022-02-02 02:02:02' LIMIT…
Hi I'm trying to achieve something with my loop from my database and I don't have the solution. I think I'm close to the solution but really need help. I believe I need to make a loop in a loop…
I have a table like below which contains temperature data for the last 6 months. It takes about 30-40 readings of temperature in an hour. 'time' is in epoch milliseconds. time temperature 1678270897857 25 1678270777712 30 1678270657548 38 1678270537402 27…
For eg :- Select * from test table where some_words IN("some1","some2") So in this query how can I write this in stored procedure where the values passed in IN() parameter is user passed values. In stored procedure- Create definer Test(In…
I have a script that's taking some comma separated IDs as an argument, and I want to check if they are valid inputs, i.e. they should be a subset of IDs present in a postgres table. I have this one…
I am trying to find all the rows in my table, which a certain column is duplicated in them. and identify them by the unique id column that each row has. I want to delete them and leave only one…
In Google BigQuery I have a column in a table which contains JSON objects similar to this one select JSON '[{"id":"A","value":"1"},{"id":"B","value":"2"},{"id":"C","value":"John"},{"id":"D","value":null},{"id":"E","value":"random"}]' as JSON_ I want to create a new column with the value of the JSON object where the id…
here is my dataset processed_on|status | ------------+-------+ 2023-01-01 |Success| 2023-01-02 |Success| 2023-01-03 |Success| 2023-01-04 |Fail | 2023-01-05 |Fail | 2023-01-06 |Success| 2023-01-07 |Fail | 2023-01-08 |Success| 2023-01-09 |Success| expected output is -------------------------- start_date|end_date|status -------------------------- 2023-01-01|2023-01-03|Success 2023-01-04|2023-01-05|Fail 2023-01-06|2023-01-06|Success 2023-01-07|023-01-07|Fail 2023-01-08|2023-01-09|Success i…