sql query problem

I have a table that has a primary key of number, code, month

Let's say that I have the following data

number code month
------ ---- -----

1      a     1
1      b     1
1      b     2

I want to formulat a query so that I get only the rows with the greatest month values for number and code. So the result of my query for the example would be

number code month
------ ---- -----

1      a     1
1      b     2

I know this is probably easy, but I would appreciate any help. Thanks,
Heather Received on Fri Jan 19 1996 - 00:00:00 CET