Create a report for the HR department that displays employee last names, department numbers, and all the employees who work in the same department as a given employee. Give each column an appropriate label.
RE: Create a report for the HR department that display...
Say for ex: Emp data in Table 1 and Dept Name in Table 2.
Now to get a report on employees department wise make a script of filtering data where the employee and his dept is xxxxxx from Table 1 making base dept from Table 2. Similarly the other way also the report can be taken maximum number of employees in a particular department also.
RE: Create a report for the HR department that displays employee last names, department numbers, and all the employees who work in the same department as a given employee. Give each column an appropriate label.
The query can be in the form
SELECT EMP_NAME DEPT FROM EMP WHERE DEPT (SELECT DEPT FROM EMP WHERE EMP_NAME 'ABC');
RE: Create a report for the HR department that displays employee last names, department numbers, and all the employees who work in the same department as a given employee. Give each column an appropriate label.
select e.department_id department e.last_name employee c.last_name colleague from employees e employees c where e.department_id c.department_id and e.last_name <> c.last_name;
RE: Create a report for the HR department that displays employee last names, department numbers, and all the employees who work in the same department as a given employee. Give each column an appropriate label.
