I have a select query 

```
Select col1,col2,col3 
from table;

```

The table contains following rows

```
col1 col2 col3 
A    | B  | C
B    | A  | C
C    | B  | C

```

I need to get the distinct result which contains a single combination A,B,C by comparing multiple columns.

Result Should be some thing like 

```
col1 col2 col3 
A    | B  | C

```

the order can be changed of result rows.

How can I achieve this ?