Hi
I have a table
ID, Unit, Department
I need your help to extract the records (not the count ) but to filter those IDs that are duplicates but the department for them are not the same
I want a query that gets me the two records of ID (2) because they are duplicated and not sharing the same department
I have a table
ID, Unit, Department
I need your help to extract the records (not the count ) but to filter those IDs that are duplicates but the department for them are not the same
1 | Unit1 | Dep1 |
1 | Unit2 | Dep1 |
3 | Unit3 | Dep3 |
2 | Unit1 | Dep1 |
5 | Unit2 | Dep3 |
2 | Unit3 | Dep2 |
I want a query that gets me the two records of ID (2) because they are duplicated and not sharing the same department