Consider the following two tables emp1 and emp2
emp1
| Id | name |
| 1 | amit |
| 2 | punita |
emp2
| Id | name |
| 1 | punita |
| 2 | anand |
What is output of the following query.
SELECT name from emp1 minus SELECT name from emp2
1
punita
2
amit
3
anand
4
amit punita
Consider the following two tables emp1 and emp2
emp1
| Id | name |
| 1 | amit |
| 2 | punita |
emp2
| Id | name |
| 1 | punita |
| 2 | anand |
What is output of the following query.
SELECT name from emp1 minus SELECT name from emp2