| |
GeekInterview.com > Interview Questions > Oracle > Basics
| Print | |
Question: 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.
|
| September 09, 2007 06:44:42 |
#1 |
| srinivas.addala |
Member Since: April 2007 Total Comments: 3 |
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.
Srinivas |
| |
Back To Question | |
