Advertisement
Maks140888

Untitled

May 31st, 2022
1,264
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.37 KB | None | 0 0
  1. select LPAD(' ', 5*level)||objects.name as "exersize3"
  2. FROM objects JOIN object_types USING (object_type_id)
  3. where level < (
  4.     select level from objects where name = 'ін-94-1'
  5.     start with parent_id is null CONNECT by prior object_id = parent_id
  6.     ) + 1
  7.     START WITH objects.name = 'ін-94-1'
  8.         CONNECT by prior objects.object_id = objects.parent_id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement