Question: Need help in SQL 1.Create a copy of the emp table as follows: -create table emp2 as select * from emp; -add the following row
Need help in SQL
1.Create a copy of the emp table as follows:
-create table emp2 as select * from emp;
-add the following row to the table:
insert into emp2 values(2050, 'CLINTON', 'MANAGER', 7839, (SYSDATE-30), 3000, 0, 40);
-insert another row into the table emp2 using your own last name and whatever data you want.
2.Write a sql statement that gives the row difference between emp and emp2.
3.Write a sql statement that performs a union between emp and emp2. Rerun the sql statement using the union all clause. Describe the difference between the 2 statements.
4.Write a sql statement that intersects emp and emp2.
emp table has the following columns(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
