select *
    from (
        SELECT
            RANK() over(partition by emplid order by effdt desc, effseq desc) AS rn
        from PS_JOB
)
  where rn = 1
/