Question: .Write a query to update the employees salaries, who are working as REP on the basis of 22 percentage (22%). .Write a query to

.Write a query to update the employees salaries, who are working as

.Write a query to update the employees salaries, who are working as REP on the basis of 22 percentage (22%). .Write a query to list out the department ID having at least three employees. . Write a query to delete the employees who are working in Public Relations department. . Write a query to show the Nth highest salary drawing employee details show job ID for jobs with average salary less than 15600. Write a query to show departments in which more than six employees have commission pct. . Write a query to show employee ID for employees who have done more than one job in the past. . Write a query to show the job ID of jobs that have been completed for more than 80 days by more than three employees. .Write a query to show department ID, year, and no. of employees joined. Write a query to show departments where any manager is managing less than four employees. Write a query to change salary of employee 115 to 9500 if the existing salary is less than 7500. . Write a query to insert a new employee into employees with all the required information. : Write a query to delete departments 40 and 240. . Write a query to change job ID of employee 177 to CLERK if the employee belongs to department 80 and the existing job ID does not start with SH. . Write a query to insert a row into departments table with manager ID 120 and location ID in any location ID for city Switzerland. PART 1 NOTE// PLEASE USE ORACLE 10g SOFTWARE DATABASE TO ANSWER THE QUESTION AND GET GIVEN TABLES FROM IT.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

1 Update employees salaries who are working as REP on the basis of 22 sql UPDATE employees SET salary salary 122 WHERE jobid REP 2 List department IDs ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!