quickie for a non-blonde!

[Helen M Hudson]

If I have a table
primary key id   |  code            | name
1                       |  ABC           | company 1 name
2                       |  ABC           | company 1 name
3                       |  ABC           | new company 1 name
4                       |  ABC           | new company 1 name
5                       |  DEF            | company 2 name
6                       |  DEF            | company 2 name
7                       |  DEF            | new company 2 name
8                       |  DEF            | new company 2 name

(the company is changing name every now and then and i need to extract their 
"latest" name)

how can i get back
4                       |  ABC           | new company 1 name
8                       |  DEF            | new company 2 name