Saturday, June 6, 2020

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)


WORKSON TABLE DATA INSERTION (COMPANY DATABASE NAVATHE BOOK )

WORKSON TABLE DATA INSERTION (COMPANY DATABASE NAVATHE BOOK )