18. Select the names of employees whose salary does not match with salary of any employee in department 10.(COMPANY DATABASE NAVATHE BOOK)
Total Pageviews
988,681
Saturday, June 6, 2020
17. Retrieve a list of employees and the project name each works in, ordered by the employee's department, and within each department ordered alphabetically by employee first name. (COMPANY DATABASE NAVATHE BOOK)
17. Retrieve a list of employees and the project name each works in, ordered by the employee's department, and within each department ordered alphabetically by employee first name. (COMPANY DATABASE NAVATHE BOOK)
16. Increase the salary of all employees working on the 'ProductX' project by 15%. Retrieve employee name and increased salary of these employees.(COMPANY DATABASE NAVATHE BOOK)
16. Increase the salary of all employees working on the 'ProductX' project by 15%. Retrieve employee name and increased salary of these employees.(COMPANY DATABASE NAVATHE BOOK)
15. Make a list of all project numbers for projects that involve an employee whose last name is 'Narayan‟ either as a worker or as a manager of the department that controls the project.(COMPANY DATABASE NAVATHE BOOK)
15. Make a list of all project numbers for projects that involve an employee whose last name is 'Narayan‟ either as a worker or as a manager of the department that controls the project.(COMPANY DATABASE NAVATHE BOOK)
14. Retrieve all combinations of Employee Name and Department Name. (COMPANY DATABASE NAVATHE BOOK)
14. Retrieve all combinations of Employee Name and Department Name. (COMPANY DATABASE NAVATHE BOOK)
13. For each employee, retrieve the employee's name, and the name of his or her immediate supervisor.(COMPANY DATABASE NAVATHE BOOK)
13. For each employee, retrieve the employee's name, and the name of his or her immediate supervisor.(COMPANY DATABASE NAVATHE BOOK)
12. For every project located in 'Stafford', list the project number, the controlling department number, and the department manager's last name, address, and birthdate.(COMPANY DATABASE NAVATHE BOOK)
12. For every project located in 'Stafford', list the project number, the controlling department number, and the department manager's last name, address, and birthdate.(COMPANY DATABASE NAVATHE BOOK)
11. Retrieve the name and address of all employees who work for the 'Research' department(COMPANY DATABASE NAVATHE BOOK)
11. Retrieve the name and address of all employees who work for the 'Research' department(COMPANY DATABASE NAVATHE BOOK)
10. Retrieve SSN and department name for all employees.(COMPANY DATABASE NAVATHE BOOK)
10. Retrieve SSN and department name for all employees.(COMPANY DATABASE NAVATHE BOOK)
9. Retrieve the names of all employees who do not have supervisors(COMPANY DATABASE NAVATHE BOOK)
9. Retrieve the names of all employees who do not have supervisors(COMPANY DATABASE NAVATHE BOOK)
8. Retrieve all employees in department 5 whose salary is between 50,000 and 60,000(inclusive)(COMPANY DATABASE NAVATHE BOOK)
8. Retrieve all employees in department 5 whose salary is between 50,000 and 60,000(inclusive)(COMPANY DATABASE NAVATHE BOOK)
7. Retrieve all employees who were born during the 1950s.(COMPANY DATABASE NAVATHE BOOK)
7. Retrieve all employees who were born during the 1950s.(COMPANY DATABASE NAVATHE BOOK)
6. Retrieve all employee names whose address is in „Bellaire‟(COMPANY DATABASE NAVATHE BOOK)
6. Retrieve all employee names whose address is in „Bellaire‟(COMPANY DATABASE NAVATHE BOOK)
5. Retrieve all distinct salary values. (COMPANY DATABASE NAVATHE BOOK)
5. Retrieve all distinct salary values. (COMPANY DATABASE NAVATHE BOOK)
4. Retrieve the name and salary of every employee.(COMPANY DATABASE NAVATHE BOOK)
4. Retrieve the name and salary of every employee.(COMPANY DATABASE NAVATHE BOOK)
3. Retrieve the birthdate and address of the employee whose name is 'Franklin T. Wong'(COMPANY DATABASE NAVATHE BOOK)
3. Retrieve the birthdate and address of the employee whose name is 'Franklin T. Wong'(COMPANY DATABASE NAVATHE BOOK)
2. Display ssn, lname, fname, address of employees who work in department no 7. (COMPANY DATABASE NAVATHE BOOK)
2. Display ssn, lname, fname, address of employees who work in department no 7. (COMPANY DATABASE NAVATHE BOOK)
1. Display all the details of all employees working in the company. (COMPANY DATABASE NAVATHE BOOK)
1. Display all the details of all employees working in the company. (COMPANY DATABASE NAVATHE BOOK)
DEPENDENT TABLE DATA INSERTION (COMPANY DATABASE NAVATHE BOOK)
DEPENDENT TABLE DATA INSERTION (COMPANY DATABASE NAVATHE BOOK)
Subscribe to:
Posts (Atom)