In my company we are having an issue where people open a requisition as one Position Description and then they change it after the fact.... creating a duplicate row in our hire table. I know it's not actually a duplicate because the Position Description is different...and I understand why these records come into my query...however I need to identify only the duplicates. Can some one give me a little guidance to get the below results?
I have data that looks like this:
Current Query:
I would like to create a query that only returns the rows with conflicting Position Descriptions.....i..e. the duplicates:
New Query Expected Result:
Any help would be much appreciated. Thanks in advance.
Note: People are often hired more than once in a given period. So in order to get the duplicates it may be necessary to take both Hire Date and Employee ID into account.... i.e. If an employee is rehired they will have the same Employee ID. Thus if Employee ID #1 is hired again on say 6/1/2017 then this ID will occur in the table again.