MySQL :: DELETE rows?

Hi, I am kinda new to mysql. Here is my question: Let's say I have a table with two cols, id and number. Some of the ids are duplicated in two different rows (max. two rows). For a given such id I would like to delete the row with greater value of number.

forums.mysql.com