Return the record with the largest iteration
I have an Oracle table, called Document, that basically has the fields:
ID, Number, Revision, Iteration
There are some records that have the same Number and Revision, but
multiple iterations (1, 2, 3, etc.).
I'm trying to return all rows where iteration is the highest,
MAX(iteration), for any given Number and Revision combination.
Hopefully that makes sense. Thanks!
No comments:
Post a Comment