select only 1 pair

From: Shaozhong SHI <shishaozhong(at)gmail(dot)com>
To: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: select only 1 pair
Date: 2022-10-24 14:44:03
Message-ID: CA+i5Jwa5VR7vJ=9S-9-d_3HgxQ_MmqwLW9+vqeN=jNDUVSVCHQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

There are pair ids. Each pair is repeated.

id1 id2
1 2
2 1
3 4
4 3

How to only select 1 unique pair for each?

Regards,

David

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message 2022-10-24 14:51:26 AW: select only 1 pair
Previous Message hubert depesz lubaczewski 2022-10-16 09:21:35 Re: How to do things like \timing on in a do loop?