MCQ Test
Previous Year Papers
Practice Questions
Video Courses
About
MCQ Test
Previous Year Papers
Practice Questions
Video Courses
About
Home
Practice
DATABASE MANAGEMENT SYSTEM USING ORACLE
SET OPERATORS: UNION, UNION ALL, INTERSECT, MINUS
Problem #1566
Problem #1566
DATABASE MANAGEMENT SYSTEM USING ORACLE
<p>EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)</p><p>DEPT (DEPTNO, DNAME, LOC)</p><p>Combine results of:</p><p>* Employees with salary > 3000</p><p>* Employees with job = 'MANAGER'</p><p> Remove duplicates.</p>
Your Solution
Submit Solution
Reset