ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.


AddThis Social Bookmark Button
  Self-Inflicted SQL
Subject:   recursive sql
Date:   2008-06-09 09:59:23
From:   krmsiva
For example, the company has employiees and managers and their reporting managers also there. Find out if given employee name or id based on that retrieve the immediate manager and who is reporting to another manager

example : emp siva is reported to kumar but kumar is reported to two managers likewise