Question : I have a table that basically represents the log of records CREATE TABLE records ( id varchar(36), — […]
Tag: self-join
Looking for help reporting duplicates and null marks
Question : Someone over at StackOverflow suggested this might be the place to ask this. I hope this will question […]
Group by unknown ID, select all related rows where Column X = Y and Column X = Z
Question : I have a table that logs interactions from users with the following structure. SELECT [SessionID] ,[Question] ,[Response] ,[DateCreated] […]
self-joins in recursive CTE: `recursive reference must not appear more than once`?
Question : This is tested with PostgreSQL 9.6, but it’s a general SQL question. Is it possible to use self-joins […]
Avoid duplicates on self join
Question : Given the following table my_table : my_column —— A B C D I would like to be able […]
Many-to-many tag filter query with a junction table get slower with more tags. Can it be faster?
Question : Part 1 I have this query to find some videos containing all given tags. Here with tags 1,9,27,13,67 […]
Joining multiple subqueries
Question : I need a query that returns something in this format: pk id v1 v2 v3 v4 v5 ———————- […]
Inner join on output of a subquery
Question : We have Slot table which tells us about freetime for an employee between starttime and endtime. We need […]
Explaining what the OR operator does in the following code
Question : I ran into the following SQL code which (successfully) outputs a list of parents and the age of […]
Recursivly get a Tree Via self joined table
Question : Using other questions here & Postgresql documentation I’ve managed to build a many-to-many self joined table. However adding […]