SQL自连接查询求助：含不可排序字符串字段的查询结果修正

Hey there! I’d love to help you get that self-join working correctly. Since you mentioned var1 is an unorderable string type and your current query isn’t hitting the mark, let’s fill in a few gaps first:

• Can you share your table schema? (List out all column names and their data types—this helps understand how the data is structured)
• What’s your desired output? A quick example of what you want the results to look like would be super helpful
• Could you post the self-join query you’ve already tried? That way I can spot exactly where adjustments are needed

Once you have those details, I can walk you through modifying the query to get the results you need!

内容的提问来源于stack exchange，提问作者Manoj Agrawal