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

1 Expert Approved Answer
Step: 1 Unlock 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!