Find maximum value in one field per each group

[argniw]

I need a stored procedure or other method to find the maximum value
for each set of records. I would want to eliminate all of the non-
maximum records. An example of the data is below. For the example
below, I would want to return record 2,6,7, and 10. To pick between 7
and 8, I would want to pick the one with the minimum ID. Can anyone
supply some sample code? Note that some people may have only one
record.
ID Person Salary
1 44 20000
2 44 22000
3 44 21000
4 45 50000
5 45 51000
6 45 53000
7 46 45000
8 46 45000
9 46 40000
10 47 10000

[John Winterbottom]

http://www.mvps.org/access/queries/qry0020.htm

ar****@yahoo.com wrote:

I need a stored procedure or other method to find the maximum value
for each set of records. I would want to eliminate all of the non-
maximum records. An example of the data is below. For the example
below, I would want to return record 2,6,7, and 10. To pick between 7
and 8, I would want to pick the one with the minimum ID. Can anyone
supply some sample code? Note that some people may have only one
record.
ID Person Salary
1 44 20000
2 44 22000
3 44 21000
4 45 50000
5 45 51000
6 45 53000
7 46 45000
8 46 45000
9 46 40000
10 47 10000