advertisement

Article:
  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