Here is a neat utility from Oracle to query a table recursively, and sort results among siblings:
SELECT e.id, e.name, e.manager_id
FROM employee e
START WITH ID = 1
CONNECT BY manager_ID = PRIOR ID
order siblings by e.name;
Note the 'order siblings by' clause. This can be used only with recursive queries and sorts the siblings by the name.
Thursday, February 2, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment