Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Last Employee in Hierarchy for Every Manager

3134376Feb 1 2019 — edited Feb 3 2019

Hi,

I am working on database version 12.2 and my requirement is to find out last empno in hierarchy for every manager.

You can use any of employee table from standard SCOTT or HR schema for sample data.

Thanks,

GS

Comments
Post Details
Added on Feb 1 2019
17 comments
615 views