[go: up one dir, main page]
Scribd
Upload
23 views2 pages

Week 6 Exercise

Uploaded by

vnrvjiet.aiml.c2327
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
23 views2 pages

Week 6 Exercise

Uploaded by

vnrvjiet.aiml.c2327
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Week-6

1.Give the names and salaries of the employees whose salary is maximum in their

respective departments.

2. List the employees whose salary is greater than the salaries of all employees who are

working as salesman.

3. Write a query which will return the day of the week entered in the format of sysdate.

4.List the department name where there are no employees.

5.. Generate the following list: EMPLOYEE NAME, JOB, SAL, GRADE

6.Get the manager name of jones.

7.Get the sub – ordinates names of jones.

8.Write a query to calculate the length of time of all employees with the company.

9.List out name, job, salary, grade, department name of all employees who are not
clerks.

10. Display the most recently employed employee in each department.

11.Display each employee with name, hiredate and review date -1 year from now.

12.Display the year in which most people joined.

13. List out minimum salary of those employees under manager.

You might also like