• This will get you there!

    ;WITH CTE AS

    (

    SELECT ROW_NUMBER() OVER(PARTITION BY SIZE ORDER BY ID) RN , ID, SIZE FROM @table

    )

    DELETE FROM CTE WHERE RN <> 1

    Hope this helps!

    Cheers!