I have two queries that count the total of employees according to multiple conditions; the only thing that changes is the last two AND clauses; I don't know how I can return the results in the same query. First Query…
I'm trying to detect users first sessions. ID event_server_date Event Row_number 1 2022-10-26 09:43 abc 1 1 2022-10-26 09:45 cde 2 1 2022-10-26 09:47 ykz 3 1 2022-10-26 09:48 fun 4 1 2022-10-26 09:50 start_event 5 1 2022-10-26 09:55 x…
I have a large PostgreSQL DB table. From this table I need to take rows grouped by Car_id and position columns. The problem is that I have a lot of duplicates and need to take one row with the best…
I am trying to identify sum of quantity for each group if date ranges are overlapping. I am using postgresql to solve for it. For example id group start_date end_date quantity 1 a 2020-09-11 2020-10-09 50 1 a 2020-09-11 2020-10-31…
I have a hard time understanding why I can refer to the output columns in returns table(col type). There is a subtle bug in the below code, the order by var refers to res in returns, not to data1 which…
In my table Product in MySQL I would like to count how many Product_Id has been Saved in Fav, Purchased or Delivered. Then organize the result in rows with null or not null by Fav, Purchase, Delivery in column or…
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 have a WordPress website and following a change of theme I have to modify the structure of a thousand links present on about fifty pages. I would like to do it in SQL via PHPMYADMIN. Is there a way…
If I have a table like this: CREATE TABLE mytable ( id SERIAL, content TEXT, copyofid INTEGER ); Is there a way to copy id into copyofid in a single insert statement? I tried: INSERT INTO mytable(content, copyofid) VALUES("test", id);…
How could I extract only alphabets of this column not considering characters after number? Also, there are situations where there are no numbers. In this case, is it possible to create a condition using CASE and WHEN to apply extraction…