I have 3 columns as user_id, start_date, end_date. as an example; user_id start_date end_date 1 2022-07-30 2025-07-30 2 2022-05-25 2027-05-25 I want to create rows based on start_date and end_date with yearly laps on the same date. so it should…
Say i have the following table, called graph: _id relates 1 {2, 3} 2 {4} 3 {5, 6} 4 {3, 7} 5 {} 6 {} 7 {} Here it is in graph form: graph My problem is to write a…
I have a gaps and islands SQL problem combined with a recursion. Background: I run a PostgreSQL database with school vacations and bank holidays from which I render calendar views for schools, city and what not. I code a lot…
I have Categories stored in a single table. Where there is no limit on number of childerns. I want to fetch all the linked childern categories for the provided category id: The reason for getting the hierarchy is that I…
I have one column in MySQL which is return me comma separated value , I want to convert that column in to rows. Better answer then How to convert comma separated parameters to rows in mysql? select value from table…
I have a table of this type | id | parent_id | | title | parent_id refers to the id of the same table I need to get a recursive tree for an element knowing only its parent. it will…
This is my database on mysql and I need extract concatenating all the parents and all children. id | name | parent_id | has_children 100017 | Roupas Femininas | 0 | 1 100018 | Meias | 100017 | 1 100419…
Background I'm running Postgres 11 on CentOS 7. I recently learned the basics of recursive CTEs in Postgres thanks to S-Man's answer to my recent question. The problem While working on a closely related issue (counting parts sold within bundles…
I have created a simple SQL statement to display which products customers have purchased from a woo commerce store. This is working great but i'm struggling to find a SQL function that repeats rows based on a value, maybe one…
In my PostgreSQL database I have table with such structure: | organization_id | organization_name | parent_organization_id | tree_organization_id | |-----------------|-------------------|------------------------|----------------------| | 1 | Alphabet | | | | 2 | Google | 1 | 12 | | 3 | Google…