Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- statuschangeid dupid approvalpending
- 1 1 1
- 2 1 1
- 3 1 0
- 4 2 0
- 5 2 0
- 6 2 0
- 7 3 0
- statuschangeid dupid approvalpending
- 3 1 0
- 6 2 0
- 7 3 0
- statuschangeid dupid approvalpending
- 3 1 0
- 6 2 0
- 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