Evaluate a date format from a String value – Mysql
I have a requirement where a filed value is "CAH132242F0A" from this i have to come up with a date. so here "13" is the year and so yyyy = "2013" and "224" th day. so i have to extract…
SQL: how to limit a join on the first match with criterias? – Postgresql
Here are the exemple tables: Product Prices (prd) start_date product price 2023-04-01 prod_A 10.0 2023-04-15 prod_A 20.0 2023-04-01 prod_B 20.0 Order Products (ord) order_date id product 2023-04-01 10001 prod_A 2023-04-01 10001 prod_B 2023-04-02 10002 prod_A 2023-04-02 10002 prod_B 2023-04-16 10003…
Azure Logic Apps – SQL tables to a single Email – How To
I have a stored procedure that I'm pulling data sets into Azure Logic Apps Designer. no matter what I try - nothing wants to plug into the send email function. some things that seem like a no brainer => DataOperations…
SQL: how to filter records by most recent occurrence within a cohort of people – Postgresql
I'm working with the following tables in a Postgres database: card_purchases purchaser_id purchase_date card_id 44 12/10/2021 3 3 1/27/2022 1 19 1/31/2022 2 22 2/15/2022 1 4 6/9/2022 4 17 8/20/2022 2 19 2/4/2023 2 22 3/17/2023 1 3 3/19/2023…
How to update multiple times the same rows in one update (parallel arrays) from a sub select – Postgresql
Here is the structure of the 2 tables: This is the "main" table : CREATE TEMP TABLE final_table ( idx INTEGER, pids INTEGER[], stats INTEGER[] ) INSERT INTO final_table VALUES (2733111, '{43255890, 8653548}'::int[], '{4, 5}'::int[]), (2733112, '{54387564}'::int[] , '{6}'::int[] ),…
in MySQL, MAX() command returns an incorrect result
I have a database which have columns with id, adsoyad, tag_id, map_id, xpos, ypos, and date. This database receives data from each user every 15 minutes. Each user has a unique tag_id. The structure of the "date" column is in…
Laravel bulk update with bindings
I want to make a bulk update to my users table. I am not updating multiple rows to the same field value - each field value could be different as it will be supplied from user input. I want to…
How to get special grouped by, nested json back from a sql oracle query?
The code looks like this: SELECT JSON_OBJECT( ROOM_LIGHT VALUE JSON_OBJECT ( 'START' VALUE START, 'ENDE' VALUE ENDE, 'RUN' VALUE RUNNING ) ) FROM runtime WHERE 1 = 1 GROUP BY ROOM_LIGHT; I want this JSON back: { "ROOM_LIGHT": "01": […
how to put two columns value in between clause – Mysql
I was trying to get a data between yesterday's noon to today's noon. There are two columns for time, one is called in_date(date type) and the other one is called in_time(time type). At first, i tried to put those values…
Either or Condition in Postgres SQL – Postgresql
How do I select the rows that have either X or Y in column C but not both in Postgres? Basically there should be no duplicate values in Column B. Data : A | B | C | ---------------------------------------- 1…