T
timorrill
I have a table that looks like this:
ClientID RevisionNum
---------------------------------
10000 1
10000 2
10000 3
10000 4
20000 1
20000 2
30000 1
30000 2
30000 3
30000 4
40000 1
40000 2
40000 3
I would like to great a query that will return the following records:
ClientID RevisionNum
---------------------------------
10000 4
20000 2
30000 4
40000 3
That is, I only want the record with the top value of RevisionNum.
Any suggestions?
ClientID RevisionNum
---------------------------------
10000 1
10000 2
10000 3
10000 4
20000 1
20000 2
30000 1
30000 2
30000 3
30000 4
40000 1
40000 2
40000 3
I would like to great a query that will return the following records:
ClientID RevisionNum
---------------------------------
10000 4
20000 2
30000 4
40000 3
That is, I only want the record with the top value of RevisionNum.
Any suggestions?