Shaddyjr · July 17, 2019 05:20
diff --git a/coding_challenge_2d.sql b/coding_challenge_2d.sql
 -- https://dba.stackexchange.com/questions/161901/select-pairs-a-b-excluding-b-a-with-same-value
 SELECT
    p1.Id,p2.Id,p1.Name 
 FROM Pairs p1
     JOIN Pairs p2
     ON p1.Name = p2.Name
     AND p1.Id < p2.Id
	-- https://dba.stackexchange.com/questions/161901/select-pairs-a-b-excluding-b-a-with-same-value
	SELECT
	p1.Id,p2.Id,p1.Name
	FROM Pairs p1
	JOIN Pairs p2
	ON p1.Name = p2.Name
	AND p1.Id < p2.Id