INTERVIEW QUESTIONS ON JOINS

1. Display employee name and his department name for the employees whose name starts with ‘S’
2. Display employee name and his department name who is earning 1st maximum salary
3. Display employee name and his department name of all the employees who Working for ‘Research’
4. Display ename,JOB,dname,loc of all the managers and clerks who work in accounts and SALES departments.
5. Display ename,sal,dname of all the salesman who are not located at DALLAS
6. Select ename and location all the employees who work in DALLAS
7. SELECT ENAME,DEPARTMET NAME AND LOCATION OF ALL THE EMPLOYEES WHO ARE WORKING FOR CLARK.
8. SELECT THE ENAME,JOB,DEPARTMENTAL INFORMATION FOR ALL THE ACTUAL MANAGERS