1) Display all the managers & clerks who work in Accounts and Marketing departments.
2) Display all the salesmen who are not located at DALLAS.
3) Select department name & location of all the employees working for CLARK.
4) Select all the departme
For designing the above topology you have to meet the following criteria,
Use class B having subnet mask /19
Assign sub-3 to Host LAN and sub-6 to Server LAN
Assign 2nd host IP,28th th host IP, 67 th Host,19th host IP for Host LAN
Find out the employees who are working in CHICAGO and DALLAS.
List all the Grade2 and Grade 3 emps.
Display all Grade 4,5 Analyst and Manager.
List the names of depts. Where atleast 3 are working in that department.
12th June, 2016
American International University Bangladesh
Sub: Application for absences.
For your kind information I am your student of PROGRAMMING LANGUAGE 2 course at section E. I was
absence some of y
1. SELECT TO_CHAR(HIRE_DATE,'MON-YY')
FROM EMPLOYEES E, DEPARTMENTS D, LOCATIONS L WHERE E.DEPARTMENT_ID=D.DEPARTMENT_ID
AND L.CITY = 'Seattle'
GROUP BY TO_CHAR(HIRE_DATE,'MON-YY')
HAVING COUNT(*) > 5;
2. SELECT * FROM JOBS J,EMPLOYEES E