Scribd
Upload
6 views2 pages

Employee Salary and Query Analysis

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
6 views2 pages

Employee Salary and Query Analysis

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

Week-6

[Link] 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.

[Link] the department name where there are no employees.

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

[Link] the manager name of jones.

[Link] the sub – ordinates names of jones.

[Link] a query to calculate the length of time of all employees with the company.

[Link] out name, job, salary, grade, department name of all employees who are not
clerks.

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

[Link] each employee with name, hiredate and review date -1 year from now.

[Link] the year in which most people joined.

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

You might also like