Dear All,
I have one employee master csv that have employee name, departmentname, projectname.
If the employee is the group head then in project , it mention Group head, otherwise it mentions project name
like:
Name DeptName ProjectName
saurabh softwaredept skyject
gaurav softwaredept GroupHead
manish rnd hrmanagement
rekesh rnd GroupHead
I want to show data like Deptname , Name of the grophead of this dept, No of employees.
Result like:
softwaredept gaurav 2
rnd rakesh 2
Requesting you to please provide query for this requirement.
... View more