I am trying to figure out how to write a single select that would give me all combinations of values for certain aggregations. Let me give you an example of data: COUNTRY PRODUCT VALUE cz p1 5 cz p2 10…
I've got a SQL query that selects every data between two dates and now I would like to add the time scale factor so that instead of returning all the data it returns one data every second, minute or hour.…
How do I get my sql result to display the preceding and subsequent row when where is_selected=true ? Result I am trying to get: alphabet_letter | is_selected -----------------+------------- C | f --row preceding boolean match1 D | t **--boolean match1**…
I have two tables: customers id name order_id orders id customer_id date amount I would like to get the first order for each customer so I used inner join & min on date. however, I'd like to get all order…
I'm looking for a solution where I can use a cumulative sum in combination with a group by. I have the following table: office_id time revenue 1 2022-01-01 12:00:00 100 1 2022-01-02 13:10:00 50 1 2022-01-02 17:00:00 40 Using the…
I have query: expiration >: '01-01-2022' and expiration <: '09-01-2022' My database: id | customer_id | type | expiration | 1 | 1 | Test | 03-01-2022 | 2 | 2 |Test2 | 05-01-2022 | 3 | 3 |Test3 |…
I have table that looks like the following, with many emails as well. The column product can contain NULL or No values. email date product email1 2020-12-15 20:31:18 Product1 email1 2020-12-15 20:32:28 Product1 email1 2020-12-15 20:33:48 Product1 email1 2020-12-15 20:34:23…
In a Postgres DB I have entries for "events", associated with an id, and when they happened. I need to count them with a special rule. When an event happens the counter is incremented and for the next 14 days…
Most of the blogs and stacks suggests below database for chat. message_table -id -message -conversationId -sender -receiverId conversation_table -id -conversationId Now message_table look like this. So, for the chat screen I subscribe the message table. final mySubscription = supabase .from('message_table')…
Brief I'm getting inserts into a transactions log table out of desired (logical) order - where a deposit to a an accountinstance+iteration occurs before that iteration exists, logically. Technology We're using PostgreSQL (13.x). Background I'm writing code that must be…