Symmetric Pairs

  • + 0 comments
    from Functions f 
    inner join Functions f1 on f.X = f1.Y and f.Y = f1.X
    where f.x <= f.y
    group by f.x,f.Y
    having f.x < f.y or (f.x=f.y and count(*)>1)
    order by f.x, f.y