Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Employee ID Old Value New Value Update Date
- 1 Analyst non-employee 10/1/2012
- 1 non-employee Senior Analyst 10/1/2012
- 2 Analyst non-employee 9/1/2012
- 2 non-employee Assistant Mgr. 9/1/2012
- 2 Assistant Mgr. non-employee 10/1/2015
- 2 non-employee Manager 10/1/2015
- 3 Analyst non-employee 10/1/2015
- 3 non-member Manager 10/1/2015
- 4 Analyst non-employee 9/1/2012
- 4 non-employee Senior Analyst 9/1/2012
- 4 Senior Analyst non-employee 10/1/2015
- 4 non-employee Assistant Mgr. 10/1/2015
- 4 Assistant Mgr. non-employee 10/6/2015
- 4 non-employee Manager 10/6/2015
- Employee ID Old Value New Value Update Date
- 3 Analyst Manager 10/1/2015
- select t.id, t.oldvalue, tnext.newvalue, t.updatedate
- from table t inner join
- table tnext
- on t.employeeid = tnext.employeeid and
- t.updatedate = tnext.updatedate and
- t.newvalue = 'non-employee' and
- tnext.oldvalue = 'non-employee'
- where t.oldvalue = 'Analyst' and tnext.newvalue = 'Manager';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement