Sql查找具有最长字符串的Row并删除Rest

I am currently working on a table with approx. 7.5mio rows and 16 columns. One of the rows is an internal identifier (let's call it ID) we use at my university. Another column contains a string. I am currently working on a table with approx.