I’m not sure if I’m wording what I’m looking for correctly as none of my searches have given me an answer remotely close to what I’m asking.

I have been asked to gather data where all strings within the defaultmessage column are similar, the issue is the message is unknown and so is the string count value, I have no information to search for in the WHERE clause. I have tried to run a SELF JOIN however, this did not work as it just returned all values, the table contains over 10000 rows of data, where the strings vary but are sometimes similar to each other, could someone please explain how I could go about to return this?