You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How To Count Number Of Employees In Each Department and Include It in this query

Accepted answer
12
Views
2
Comments

Summary:

How To Count Number Of Employees In Each Department and Include It in this query:


SELECT   distinct houft.name Department_Name_English, 

    ppnfv.full_name,

  FF.ATTRIBUTE3 Department_Name_ARABIC,

  FF.ATTRIBUTE1 Department_Catagory,

  CLS.STATUS STATUS,

 hoif.ATTRIBUTE_NUMBER1 Department_Code




 

  

  

FROM HR_ORGANIZATION_INFORMATION_F hoif,

   per_person_names_f_v ppnfv,

   hr_organization_units_f_tl houft,

HR_ALL_ORGANIZATION_UNITS_F FF,

HR_ORGANIZATION_UNITS_F_TL TT,

HR_ORG_UNIT_CLASSIFICATIONS_F CLS


WHERE trunc(sysdate) BETWEEN hoif.EFFECTIVE_START_DATE AND hoif.EFFECTIVE_END_DATE

AND trunc(sysdate) BETWEEN ppnfv.effective_Start_date AND ppnfv.effective_end_date

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!