I have a scenario where i have 3 columns state1 state2 and distance with 5 rows like

```
state1 state2 distance
TX      CA     100
CA      TX     100
OH      MI     400
MI      OH     400

```

since the distance from Tx to CA and CA to TX is same i only need one row out of the first 2 rows
ie either TX,CA,100 or CA,TX,100 and also the 5 rows are just sample data out of a million rows .I need a query for this scenario