validating records during data retrieval

Hi,

i have a database table with fields ID and NUMBER which contains several records with the same id and different number

example.

-ID-| NUMBER

id123| 1

id123| 3

id123| 2

i need to pick up the record with maximum NUMBER value.in this case with ID123 and NUMBER 3.

how to code the select query.

any help would be appreciated.

thanks,

kranthi.