Getting unique tuples in SQL

Question

i have a table like below i want to get unique values.

from_st     to_st       fare
---------------------------
Bangalore   Hyderabad   600
Hyderabad   Bangalore   600
Bangalore   chennai     500
chennai     Bangalore   500
Bangalore   noida       1500
noida       Banagalore  1500
bangalore   delhi       3000
bangalore   pune        2000

i need data like Bangalore to Hyderabad and Hyderabad to Bangalore are duplicates. so i want only one records among them.

desired output:

from_st     to_st       fare
---------------------------
Bangalore   Hyderabad   600
Bangalore   chennai     500
Bangalore   noida       1500
bangalore   delhi       3000
bangalore   pune        2000

I see particularly this question so many times on so many other forums and QA sites. Like http://www.orafaq.com/forum/t/197425/ and http://stackoverflow.com/questions/33873643/sql-to-get-distinct-record-for-a-combination-of-two-column-irrespective-of-orde — Lalit Kumar B, Dec 02 '15 at 11:08

score 1 · Accepted Answer · answered Dec 02 '15 at 10:47

1

You may do this:

 select distinct least(from_st, to_st), greatest(from_st, to_st), fare
 from your table;

answered Dec 02 '15 at 10:47

Florin Ghita

17,525
6
57
76

Getting unique tuples in SQL

1 Answers1