All Forums Analytics
22 Nov 2014
airlines query - cross value duplicate elimination

Hi Experts, Can you please help me logic on below -
a table has source , destination and distance.
There are some rows where destination was already there as source in some other record with source as destination. both records has same distance. (i.e., There are records with "to and from" and "from and to" both with same distance)
I need to display only one set of such records. Can you help me on this.
 
 
 

Satyanarayana
Raja_KT 1246 posts Joined 07/09
23 Nov 2014

Is it something like this what was done by Dieter?
http://forums.teradata.com/forum/database/help-on-below-sql#comment-137894

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

23 Nov 2014

Yes. Thanks Raja and Dieter.

Satyanarayana

You must sign in to leave a comment.