• Could you further explain why C is eliminated from your desired output? In fact we could use a little more info in general. Without knowing how A is related to B and/or C it's hard to look at your example and come up with a solution.

    Taking this statement literally:

    How to find the equal and opposite rows in a table.

    Should mean that A, B and C are all returned because they all meet your criteria.


    SELECT quote FROM brain WHERE original = 1
    0 rows returned