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!

SQL to fetch employee details

GlassFacetApr 15 2014 — edited Apr 18 2014

I have been facing this requirement more often nowadays but don't how to write it efficiently.

an example :

Need to find employees from companies with at least 5 managers 3 admin 2 clerks(total 10 roles) and their details

EMP table:

Comp_Id, Emp_id, Emp_name, Emp_role

Company :

Comp_Id, Comp_Name

-- I've tried to search for any existing similar questions. couldn't find anything relevant.

This post has been answered by Solomon Yakobson on Apr 17 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 16 2014

Added on Apr 15 2014

15 comments

1,380 views