Advertisement
Guest User

Untitled

a guest
Aug 21st, 2014
199
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. 1st row
  2. 3rd row
  3. 6th row
  4.  
  5. select personid, xdate, seqnumber
  6. from (
  7. select personid, xdate, seqnumber
  8. , row_number() over (partition by personid
  9. order by xdate desc, seqnumber desc) as rn
  10. from T
  11. ) as X
  12. where rn = 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement