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 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 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
Get step-by-step solutions from verified subject matter experts
