Advertisement
Guest User

Untitled

a guest
Aug 21st, 2019
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. statuschangeid dupid approvalpending
  2. 1 1 1
  3. 2 1 1
  4. 3 1 0
  5. 4 2 0
  6. 5 2 0
  7. 6 2 0
  8. 7 3 0
  9.  
  10. statuschangeid dupid approvalpending
  11. 3 1 0
  12. 6 2 0
  13. 7 3 0
  14.  
  15. statuschangeid dupid approvalpending
  16. 3 1 0
  17. 6 2 0
  18.  
  19. select dupid, approvalpending, max(statuschangeid) as maxid from tableA group by dupid, approvalpending having count(*) > 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement