In this particular case, you could do:

select distinct *

from OrderDetail

The problem with removing duplicates is that there are so many variations that no one solution fixes all. You just need to be aware of different ways of achieving the same result.

Jeremy