Answered step by step
Verified Expert Solution
Question
1 Approved Answer
can you help me with this EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO 7369 SMITH MANAGER 7902 17-DEC-80 800 20 7499 ALLEN SALESMAN 7698
can you help me with this
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO 7369 SMITH MANAGER 7902 17-DEC-80 800 20 7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30 7521 WARD SALESMAN 7698 22-FEB-SI 1250 500 30 7566 JONES MANAGER 7839 02-APR-812975 20 7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30 7698 BLAKE MANAGER 7839 01-MAY-SI 2850 30 7782 CLARK MANAGER 7839 09-JUN-SI 2450 10 7788 SCOTT MANAGER 7566 19-APR-87 3000 20 7839 KING PRESIDENT 17-NOV-81 5000 10 7844 TURNER SALESMAN 7698 08-SEP-81 1500 30 Referring to the database below, specify the following queries: Retrieve the name and job of all employees who work in department 20, and their salary exceeding 2000. SQL> Using SQL update command change the job of all employees working in department 20 to supervisor SQL> Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started