Advertisement
DimitarVasilev

Untitled

Jul 3rd, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.30 KB | None | 0 0
  1. SELECT vg.vo_group_id,
  2. vg.name,
  3. vg.vehicle_owner_id,
  4. vg.graphical_symbol,
  5. vg.lm_comment,
  6. vg.company_nr,
  7. vg.parent_vo_group_id
  8. FROM vo_group vg
  9. CONNECT BY prior vg.vo_group_id = vg.parent_vo_group_id
  10. START WITH vg.parent_vo_group_id IS NULL
  11. ORDER siblings BY vg.parent_vo_group_id, vg.vo_group_id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement