| |
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.
|
| June 06, 2008 05:04:30 |
#2 |
| shamkohli |
Member Since: June 2008 Total Comments: 5 |
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'); |
| |
Back To Question | |
