"ezt csak SQL-ből nem tudod megoldani"
```
DELETE FROM table t1
WHERE EXISTS (
SELECT 1 FROM table t2
WHERE t1.group = t2.group and t1.value = t2.value and LEFT(t1.prefix, LENGTH(t2.prefix)) = t2.prefix) and LENGTH(t2.prefix) < LENGTH(t1.prefix)
);
```