I've been investigating an issue with one of our application queries running very slowly and it seems to be related to a particular view we're using. Here is the full query with the selected columns omitted (there are 408 columns…
I have two identical databases, with two identical tables. The source database's table has data and the target database's table has no data. The tables in both databases are named testt. What the data looks like now in the source…
My table is: create table transactions transaction_id integer not null, transaction_timestamp integer not null, input_index smallint, output_index smallint not null, from_id integer, to_id integer not null, input_value real, output_value real not null, constraint unique_transactions unique (transaction_id, from_id, to_id) ); with…
This is my data. username building action timestamp user-1 building-1 IN 2024-04-10 01:00:00.000 user-1 building-1 OUT 2024-04-10 02:00:00.000 user-1 building-1 IN 2024-04-10 02:30:00.000 user-1 building-1 OUT 2024-04-10 04:00:00.000 user-1 building-1 IN 2024-04-11 10:00:00.000 user-1 building-1 OUT 2024-04-11 11:00:00.000 user-2 building-2…
I'm working on a query in Supabase where I need to select specific columns from a table based on multiple conditions. Specifically, I need to select columns a, b, and c from a table where column e is equal to…
In the database, there is a field that stores JSON, and the content is roughly as follows: "content":{"systemToken":false,"timezone":"America/Los_Angeles","totalCount":false,"userIds":[]}" The requirement is to query data where totalCount is true. SELECT * from task where column_a like '%"totalCount%' This query returns results,…
I have a table with two columns and the following data. I'm stuck with this table's structure and have no possibility of revamping it since the company has grown significantly and a lot of features depend on that particular format.…
Having customer2 table enter image description here trying to execute below command select AccountNO,id_Proof, CASE id_Proof when id_Proof in('Passport','PAN') then 'P' else id_Proof end as abc from customer2; It working opposite enter image description here please suggest why IN clause…
Let's say I have the following table: WITH tbl AS ( SELECT 1 AS id, "Phone" AS product, 105 AS cost UNION ALL SELECT 2 AS id, "Camera" AS product, 82 AS cost UNION ALL SELECT 3 AS id, "Cup"…
I have below table information Batch_ID Items Time User Batch_1 50 0.70 Abc Batch_2 40 0.70 Abc Batch_2 60 0.70 Abc I want SQL code where I can calculate the SUM of Items and the SUM of Time but I…