I have a table which is as follows:

```
Name   DisplayID InventoryType Itemlevel RequiredLevel  
Armor1      4           4         566      90
Armor2      123         30        566      90
Armor3      123         30        540      90
Armor4      123         10        540      90

```

What I want to do is, delete The DisplayId Duplicates From Each InventoryType and leaving the one with the Highest Itemlevel.

HeidiSQL, MySQL