Re: select only 1 pair
| От | William Alves Da Silva |
|---|---|
| Тема | Re: select only 1 pair |
| Дата | |
| Msg-id | 7f09c27c-c4df-4836-bd29-706ebc5eb154@Spark обсуждение исходный текст |
| Ответ на | select only 1 pair (Shaozhong SHI <shishaozhong@gmail.com>) |
| Ответы |
Re: select only 1 pair
|
| Список | pgsql-sql |
Hello David,
Try this.
This is an exemple of your table.
SELECT *
FROM (VALUES (1, 2), (2, 1), (3, 4), (4, 1)) t (id1, id2)
id1 |id2 |
------+------+
1| 2|
2| 1|
3| 4|
4| 1|
I think that is what you need
SELECT DISTINCT LEAST(id1, id2) AS id1, GREATEST(id1, id2) AS id2
FROM (VALUES (1, 2), (2, 1), (3, 4), (4, 3)) t (id1, id2)
id1 |id2 |
------+------+
1| 2|
3| 4|
Try this.
This is an exemple of your table.
SELECT *
FROM (VALUES (1, 2), (2, 1), (3, 4), (4, 1)) t (id1, id2)
id1 |id2 |
------+------+
1| 2|
2| 1|
3| 4|
4| 1|
I think that is what you need
SELECT DISTINCT LEAST(id1, id2) AS id1, GREATEST(id1, id2) AS id2
FROM (VALUES (1, 2), (2, 1), (3, 4), (4, 3)) t (id1, id2)
id1 |id2 |
------+------+
1| 2|
3| 4|
Regards,
William Alves
On 24 Oct 2022 11:44 -0300, Shaozhong SHI <shishaozhong@gmail.com>, wrote:
There are pair ids. Each pair is repeated.id1 id21 22 13 44 3How to only select 1 unique pair for each?Regards,David
В списке pgsql-sql по дате отправления: