SQL Server How to Distinct Values from Different Columns in SQL

a5g8bdjr 于 12个月前发布在其他

关注(0)|答案(1)|浏览(111)

I got a table like :
| Column A | Column B |
| ------------ | ------------ |
| 13 | 24 |
| 24 | 13 |
| 16 | 89 |
| 89 | 16 |

Since they include the same values in different columns for example 16-89 89-16 doesn't make a difference for my table and they duplicate. Can you help me on how to remove them? What I wanna reach is

Column A	Column B
13	24
16	89

Column A	Column B
24	13
89	16

Doesn't make any difference for my data. Thank you all.

I couldn't reach anything. I tried to Distinct data but it doesn't work anyway.

sql-server

来源：https://stackoverflow.com/questions/77577838/how-to-distinct-values-from-different-columns-in-sql

1条答案

按热度按时间

xiozqbni1#

This can be done using LEAST and GREATEST :

SELECT DISTINCT LEAST(ColumnA, ColumnB) AS ColumnA, GREATEST(ColumnA, ColumnB) ColumnB
FROM mytable

Demo on sql server 2022

If LEAST and GREATEST are not supported :

SELECT DISTINCT IIF(ColumnA < ColumnB, ColumnA, ColumnB) AS ColumnA, -- LEAST
                IIF(ColumnA > ColumnB, ColumnA, ColumnB) AS ColumnB  -- GREATEST
FROM mytable

Demo here

赞(0）回复(0）举报 12个月前

我来回答

SQL Server How to Distinct Values from Different Columns in SQL

1条答案

相关问题

热门标签

最新问答