The MINUS query will compare each record in statement1 to a record in statement2. The result returned will be records in Select Statement1 that are not in Select statement2.
Syntax: [SQL Statement 1] MINUS [SQL Statement 2]
SELECT ENAME, EMPNO FROM EMP WHERE ENAME LIKE ‘M%,‘ OR ENAME LIKE ‘J%,‘;
SELECT ENAME, EMPNO FROM EMP WHERE ENAME LIKE ‘J%‘ OR ENAME LIKE ‘A%‘;
On execution it will return those rows which exist in first statement only. It will not display common rows at all.