Posted by J.Balakumar on 12/09/05 10:09

Dear sir,
I am balakumar here,
I have created a database of a company like the whole company employee
is under MD.
but i want number of employee forming a branches who is directly
reporting to there immediate senior.
I want the maximum number of subordinates reporting to their
immediate(Direct) senior.
what would be the <syntax> in nested select option.
I request you to send the <syntax> to my mail ID at the earliest.


MODEL OF MY DATA"S
like....

The hierchy of the company is
MD > 3 Director > each director have 2,3,and 4 subordinates
respectively.
I want the maximum number of subordinates Reporting to direct
(immediate) senior.

Thanking you,

With Regrads,
J.Balakumar


> *** Sent via Developersdex http://www.developersdex.com ***

• Next in forum: Re: datetime
• Prev in forum: Re: Database security (crosspost)
• Thread view: Execution of maximum number of Direct subordinate in an organization

[Reply to this message]