I'm quite new to sql so I don't quite know what is the correct approach to fix my problem. I have two tables, events and labels that have many-to-many relations on id field. i also create junction table for them.…
I have to group by the different vendors in each given year by calculating the total sales for those years. I could only get the first column. Output obtained query=''' SELECT ven.nombre_vendedor, SUM(total-costo_envio) AS año2019 FROM itens_pedidos ip INNER JOIN…
I want to use SELECT clause inside the VALUES like this: The point is to get a random value from another table VALUES (SELECT x FROM seq_data ORDER BY RAND() LIMIT 1;, ...) Yet this returns an error, Otherwise I…
I have a table named tbl_user_complete and a query like this: user_id bill_id complete_date user_1 bill_1 2024-01-14 user_1 bill_2 2024-02-14 user_1 bill_3 2024-05-01 user_2 bill_4 2024-01-03 SELECT user_id , bill_id , MAX(complete_date) AS complete_date FROM tbl_user_complete GROUP BY user_id; I…
I have a table workflows with an auto-incrementing primary key called 'click_id'. I would like to add a field 'id' at the beginning of the table and make that the auto incrementing primary key. This is the migration that fails:…
I'm trying to extract every data in my column that are in between "" "": here are sample data: Column A {""Activity"":""ConnectFromExternalApplication"",""Id"":""xz[we-654231-aja"",""RecordType"":20,""CreationTime"":""2024-02-13T17:59:44"",""Operation"":""ConnectExternal"",""OrganizationId"":""[REDACTED]"",""UserType"":0,""UserKey"":""bb0-649-429-a53f-b6328"",""Workload"":""BI"",""ResultStatus"":null,""UserId"":""bb0-16-4219-a53f-665328"",""ClientIP"":null,""CustomData"":""""} {""Id"":""f120-00c3-4ddb-ba60-c9ed83df0"",""RecordType"":20,""CreationTime"":""2023-03-13T17:46:14"",""Operation"":""ViewReport"",""OrganizationId"":""[REDACTED]"",""UserType"":0,""UserKey"":""100300009C22A108"",""Workload"":""PowerBI"",""UserId"":""[email protected]"",""ClientIP"":""213.174.203.7"",""Activity"":""ViewReport"",""ItemName"":""Opt Dashboard"",""WorkSpaceName"":""UK Operational Reports"",""DatasetName"":""Operational Dashboard"",""ReportName"":""Operational Dashboard"",""CapacityId"":""82EF1AA9-0554-4E95-B249-15F"",""CapacityName"":""BI UK Capacity 1"",""WorkspaceId"":""6588ee54-5b73-441d-a3ac-f133f"",""AppName"":""UK Operational Reports"",""ObjectId"":""Operational Dashboard"",""DatasetId"":""1cd1ce2f-9395-4be0-9521-3e38e7e236b8"",""ReportId"":""76d769fd-a9ec-4c77-ac3d-7cd57d9449ca"",""ArtifactId"":""76d769fd-a9ec-4c77-ac3d-7cd57d9449ca"",""ArtifactName"":""Opt Dashboard"",""IsSuccess"":true,""ReportType"":""PowerBIReport"",""RequestId"":""a2214fde-dffc-7c30-083c-6702b7"",""ActivityId"":""f61bed2a-5906-425c-8048-682a779900aa"",""AppReportId"":""e0ab7628-73b5-4832-9161-c966996d293e"",""DistributionMethod"":""Apps"",""ConsumptionMethod"":""Power BI Web"",""AppId"":""e44d1e27-1d9d-4585-a477-fb66fcd"",""ArtifactKind"":""Report""} value such as…
This is a follow up to this question: Possible to "unpivot" in SQL when ingested from JSON. Let's say I have the following SQL table with data that was incorrectly inserted from a JSON document: X1AB_name X1AB_age Y2AL_name Y2AL_age "Todd"…
I have a H2 database (version 2.2.220) with data in a JSON column; I need to migrate the column via a SQL script so that the data is in a conventional relational database structure. The main stumbling block is that…
I have requirement where bash script will pass on the string consisting tables names to anonymous PL/pgSQL block which will process the tables if they exists in the Postgres db. Below is the PL/pgSQL code assuming given_tables variable has the…
I am struggling with a Postgres slow query issue. Fixtures Consider the following fixtures: DROP TABLE IF EXISTS expectation; DROP TABLE IF EXISTS actual; CREATE TABLE expectation ( set_id int NOT NULL, value int NOT NULL ); INSERT INTO expectation…