Avoid duplicates on self join Given the following table my_table :

my_column
------
A
B
C
D


I would like to be able to join on itself but without duplicate pairs like so:

-- SELECT a.*, b.* FROM my_table a JOIN my_table b ON a.my_column &lt;&gt; b.my_column; 
-- something like so but without the duplicate pairs

a.my_column | b.my_column
------------+-----------
A           | B
A           | C
A           | D
B           | C
B           | D
C           | D


How should I tackle this in SQL ?
SELECT *
FROM my_table a
JOIN my_table b ON a.my_column &lt; b.my_column