-
distinct rows based on combination of columns
Hi,
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
Regards
Arvind
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules