I'm trying to get a record from a table, but only want to retrieve that record if there isn't another corresponding record with another status. Schema: ID: PK RID: Collection ID IID: Item ID Each ItemID correlates to a record…
I got a table clients and another table of authorization. They are tied by foreign key orgid. I want to be able to pull distinct list of clients that had any records in authorizations from 1/1/2019 to 12/31/2022 but no…
Apparently, sorting is somehow applied incorrectly in mysql 8 (checked on 8.0.33 to 8.0.35) when query has ORDER BY + GROUP BY + GROUP_CONCAT() + COUNT(*) OVER() window function. See test case below (NOTE that it's synthetic and oversimplified for…
Please check tables below and help to solve. Table A a_id name dept a_date amount 123 Clark Sales 2024-01-01 5000 124 Clark Sales 2024-01-02 6000 125 John Sales 2024-01-03 3500 126 John Sales 2024-01-04 5500 Table B b_id name dept…
I have a table sample below: Table_A col1 col2 881 113 988 899 113 765 765 765 122 881 300 400 765 910 910 345 999 988 What I want to achieve here, is to get the last chaining data…
i have a column category which has the following data: 0100 Single Function Inkjet Printers 0100 Wireless Phones 400 optics (421) 4000 sound and recording (267) 80000 electrical & heating (60) 81000 plumbing Accessories Action Figures/Collectibles I am trying to…
I used springboot+JPA+Hibernate to insert data. But the insertion speed of the first data is too slow, and it becomes faster later. I want to eliminate this situation and make all data insertions fast, including the first one. Is there…
I have a table say t_records which has a JSON type column say col_json which can have value like below { "1": { "value": null, "comment": null, "timestamp": null, "guidelineId": null, "pushedToSnowflakePipeline": "yes" }, "2": { "value": null, "comment": null,…
So I have a MYSQL table, and one of the columns (call it TAGS) is an array which contains a list of tag names. For example, a given entry could have a TAGS column value of "TAG A, TAG B,…
I am working with an Excel spreadsheet that contains dates in the German format DD.MM.YYYY, and I'm trying to craft a formula that automatically generates an SQL insert statement for each row. I'm running into issues converting the German date…