Logical duplicates

From: <rajugaru.vij_at_gmail.com>
Date: Fri, 28 Jun 2013 08:06:13 +0000
Message-ID: 412847735-1372406779-cardhu_decombobulator_blackberry.rim.net-1988350947-_at_b3.c12.bise7.blackberry>

Hi,
I have a table, called travel, with columns (source,destination,distance) this is something like, New york to paris and distance between them.

Logically New York to paris or Paris to New York both are same in distance.

But I have two entries for that, I waant to delete all such records.

Any suggestions?

Thanks
Sent on my BlackBerry® from Vodafone--
http://www.freelists.org/webpage/oracle-l Received on Fri Jun 28 2013 - 10:06:13 CEST