Can I read Employee Salary and Job Queries on EtoBox?
Employee Salary and Job Queries by Karuna Mittal is a document available to read on EtoBox.
What is Employee Salary and Job Queries about?
The document contains sample data from an EMP database table with columns for employee number, name, job, manager, hire date, salary, and department number. It also contains 10 queries against this and other sample tables: 1. List job titles and salaries of employees managed by 7698 or 7566 earning over 1500. 2. Get the number of tuples in EMP and unique job titles. 3. Transfer employee JONES to department 20 as a manager and increase salary by 1000. 4. Set salesmen in department 20 to the lowest man
- Author
- Karuna Mittal
- Language
- EN