I've tried all afternoon to dedup a table that looks like this: ID1 | ID2 | Date | Time |Status | Price ----+-----+------------+-----------------+--------+------- 01 | A | 01/01/2022 | 10:41:47.000000 | DDD | 55 01 | B | 02/01/2022 |…
WITH RECURSIVE CTE AS (SELECT MIN(period_start) as date FROM Sales UNION ALL SELECT DATE_ADD(date, INTERVAL 1 day) FROM CTE WHERE date <= ALL (SELECT MAX(period_end) FROM Sales)) What is the difference of using ALL in the where clause and not…
I have two tables in my database that looks like this learner_lessons learnerlessonid learnerid lessonid 1 24 42 learner_lesson_logs lessonlogid learnerlessonid progress maxprogress interaction createdAt 1 1 0 15 Start 2022-11-02 07:51:30 2 1 4 15 Pause 2022-11-02 07:51:34 3…
I have the following table called "profile": id, name, created_at Every user ( with SupaBase ) has his own row in the "profile" table with his user_id as the key ( id ) I added RLS so that only the…
I am trying to create a cumulative count for unique customers only by the month they purchased. The example Table is: customer_email cohortMonth [email protected] 10/2019 [email protected] 10/2019 [email protected] 10/2019 [email protected] 11/2019 [email protected] 11/2019 [email protected] 12/2019 The output I am looking…
We have mysql table with below columns. I am given startDate and endDate and now I have to fetch rows between those dates. Can some one please help with mysql query with how I can get those rows? For example…
I have a table like this: value ts 2.0 1 3.0 5 7.0 3 1.0 2 5.0 4 I need to select max value, min value and value with max ts. Is it possible to do it with one query?…
I'm trying to make an sql request that turned out surprisingly difficult to me (or maybe this is just the end of the day, sigh). I have 3 tables: Team: id 1 2 3 Team member table: id team_id 1…
I have a database having columns id and profile fields where profile fields is of the type jsonb id profile_fields 101 {"1":"Chess" , "2":"08-02-2001"} 102 {"1":"Hockey" , "2":"1996-06-09"} In profile fields the key 2 stands for Date of Birth .…
I have a table with dates and some other information, where the dates are not continuous (no weekends). How do I get all records from the last two days/dates (which I don't necessarily know beforehand)? While SELECT datum FROM trackproc…