I'm having great difficulty writing this query and cannot find any answers online which could be applied to my problem. I have a couple of tables which looks similar to the below with. Each purchase date corresponds with an item…
I am using this code to see the unique results of concated/joined columns 'a,b' from table1 and is working perfectly WITH tt as ( SELECT concat(a,',',b) AS concated FROM table1 GROUP BY concated ) select concated from tt; But, instead…
I have the same issue listed in this SO question, but I have tried the solution and I am getting a SQL error 1288- I'm thinking I am poorly translating SQL server to SQL or this method has been deprecated.…
I have a quick question in relation to windowing in MySQL SELECT Client, User, Date, Flag, lag(Date) over (partition by Client,User order by Date asc) as last_date, lag(Flag) over (partition by Client,User order by Date asc) as last_flag, case when…
I've been stuck on this SQL query for a day now, so I'm throwing it up here and would appreciate any advice others can give. This is the problem: I want to generate a set of pairs of tags (named…
In this dbfiddle demo I have a DELETE FROM... WHERE at the end like so: ...... DELETE FROM data_table WHERE (location, param_id, ref_time, fcst_time) NOT IN (SELECT location, param_id, ref_time, fcst_time FROM sel1) AND (location, param_id, ref_time, fcst_time) NOT IN…
here I have tried to rewrite the query with cte cuz of good readability but when I try to rewrite the data is mismatched how to solve the problem for this? Query; select count(1) as rage_tap from ue_summary.summary_funnel_1066 s join…
I am trying to calculate the number of users who have an active subscription on a particular day. I also want information related to the subscription plan they are on. I have a subscriptions table which includes the start date…
I have a query that orders the result by a specific none-unique column. Now I want to get the first N rows after a specific ID (the primary key). I have a table similar to this: ID Size 0 3…
I've recently switched from V11 to V14 of PostgreSQL, and some of my CTE queries, that used to take a few milliseconds, now takes a few seconds. The minimum query to reproduce this issue is the following : WITH MyTable…