I have the table for train journey col 1 - From destinationn col 2 - To Destination col C distance
now i want to write a query to ge the unique journeys that are available?
for example there will be rows for
From - London To Paris
From Paris To London,
basically both are same trip, so wanted to get just one in my result?
how do i write a query to get this