Advertisement
Guest User

Untitled

a guest
Oct 6th, 2015
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.24 KB | None | 0 0
  1. Employee ID Old Value New Value Update Date
  2.  
  3. 1 Analyst non-employee 10/1/2012
  4.  
  5. 1 non-employee Senior Analyst 10/1/2012
  6.  
  7. 2 Analyst non-employee 9/1/2012
  8.  
  9. 2 non-employee Assistant Mgr. 9/1/2012
  10.  
  11. 2 Assistant Mgr. non-employee 10/1/2015
  12.  
  13. 2 non-employee Manager 10/1/2015
  14.  
  15. 3 Analyst non-employee 10/1/2015
  16.  
  17. 3 non-member Manager 10/1/2015
  18.  
  19. 4 Analyst non-employee 9/1/2012
  20.  
  21. 4 non-employee Senior Analyst 9/1/2012
  22.  
  23. 4 Senior Analyst non-employee 10/1/2015
  24.  
  25. 4 non-employee Assistant Mgr. 10/1/2015
  26.  
  27. 4 Assistant Mgr. non-employee 10/6/2015
  28.  
  29. 4 non-employee Manager 10/6/2015
  30.  
  31. Employee ID Old Value New Value Update Date
  32.  
  33. 3 Analyst Manager 10/1/2015
  34.  
  35. select t.id, t.oldvalue, tnext.newvalue, t.updatedate
  36. from table t inner join
  37. table tnext
  38. on t.employeeid = tnext.employeeid and
  39. t.updatedate = tnext.updatedate and
  40. t.newvalue = 'non-employee' and
  41. tnext.oldvalue = 'non-employee'
  42. where t.oldvalue = 'Analyst' and tnext.newvalue = 'Manager';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement