TABLEA:
id
scu

DELETE FROM TABLEA
WHERE id NOT IN (
(
SELECT MAX(id)
FROM TABLEA
GROUP BY scu
)
)

Any ideas why it's throwing that error?