CIS 411w spring 2017 Problem Set 13

UNION operator

1. Create report for the managers of the company that shows the empno, ename, job, sal, and commission for all the employees using the data in the emp table. This is a report for the managers so we dont want the other managers to know what each of their fellow managers is earning so use the UNION operator to show the sal and comm for managers as zeroes.

Copy and paste your SQL code into this assignment.

MINUS operator

2. Write a report for the president of the company that shows the empno, ename, job, mgr, deptno from emp. Use the MINUS operator to get rid of the record in the result set for the president since he doesnt want to see any information about himself.

Copy and paste your SQL code into this assignment.

INTERSECT

3. Write a SQL query that shows empno, ename, job, mgr, deptno from emp. Use the INTERSECT operator to show only those employees who have an empno = 7902 or7839.

Copy and paste your SQL code into this assignment.

Submit your assignment to the Problem Set 13 Drop Box.