Skip to content
Advertisement

Delete rows where string value appears inside another row value that is larger

I am trying to make a table smaller by removing values that appear inside other larger values. e.g.

The outcome I want is for row 2 and 3 to be deleted from the table as they both appear inside of another row that is larger than them.

I have tried to write code for it but without being able to use Inner Joins in the DELETE statement I don’t know how to do it without having a subquery return multiple elements.

Advertisement

Answer

You should be able to use:

User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement