I have two tables, roles and permissions, both of which use ltree for maintaining a tree structure. I also have a pivot table, roles_permissions, which serves to connect the two tables. How can I join ...
Given the following table my_table :
I would like to be able to join on itself but with avoiding duplicate pairs like so:
-- SELECT a.*, b.* FROM my_table a JOIN my_table b ...
I have a question here which need your kindly help.
I have a table with the following data
And then I want to write ...
We have Slot table which tells us about freetime for an employee between starttime and endtime.
We need to find Slot which have freetime > 'x' mins. This could be either be a complete slot or it can ...
I am trying to find a way to get the employee hierarchy in an organization using JPA and Spring boot.
The problem is similar to the following link
Similar Data Model
If A reports to B and B reports ...
I have a query that takes 10 minutes to run (1.4 million rows and 15-ish joins), so I think the time isn't terrible.
What I need from this is to effectively INNER JOIN on itself an additional column ...