Comparing rows within the same table

Question

Accepted Answer

The self join finds pairs of distinct products with the same price. Alpha and Gamma both cost 10.00, so they form a pair. p1.id < p2.id ensures each pair appears exactly once (order: id 1 then id 3). Beta has a unique price and forms no pair.