SELECT * INTO #sample FROM (VALUES (1, 'A'),(1,'Long A'),(2,'B'),(2,'Long B'),(2,'BB')) T(ID,Txt)

DELETE S FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY ID ORDER BY LEN(Txt) DESC) RN FROM #sample) S WHERE RN!=1

SELECT * FROM #sample