Advertisement
Guest User

Untitled

a guest
Jul 19th, 2017
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.33 KB | None | 0 0
  1. select *
  2.     from (
  3.         SELECT
  4.             RANK() over(partition by emplid order by effdt desc, effseq desc) AS rn
  5.         from PS_JOB
  6. )
  7.   where rn = 1
  8. /
  9.  
  10. select *
  11. from
  12. (
  13. select EMPLID, EFFDT, EFFSEQ, GRADE,
  14.     RANK() over(partition by emplid order by effdt desc, effseq desc) AS currentness
  15.   from PS_JOB
  16.  
  17. ) WHERE currentness = '1'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement