Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

how to find symmetric pairs in sql

SELECT f1.X, f1.Y FROM Functions AS f1 WHERE f1.X = f1.Y GROUP BY f1.X, f1.Y HAVING COUNT(*) > 1
Source by nifannn.github.io #
 
PREVIOUS NEXT
Tagged: #find #symmetric #pairs #sql
ADD COMMENT
Topic
Name
8+8 =