Today, I will discuss about the scenario/Problem which i faced in current project.
Problem Statement : You have two Employee tables having data mentioned below.
Emp-1 | |
EmpId | EmpName |
1 | Shivani |
2 | Gaurav |
3 | Radhe |
4 | Rahul |
5 | Anil |
Emp-2 | |
EmpId | EmpName |
1 | Shivani |
6 | Ashok |
3 | Radhe |
7 | Vikram |
4 | Rahul |
Output :
EmpId | EmpName |
2 | Gaurav |
5 | Anil |
6 | Ashok |
7 | Vikram |
Solution : Here, you need to use except or minus based on the database you are using and union clause. See the below query for the same.
select EmpId ,EmpName from Emp-1
except
select EmpId ,EmpName from Emp-2
union
select EmpId ,EmpName from Emp-2
except
select EmpId ,EmpName from Emp-1