airlines query - cross value duplicate elimination

Analytics
Enthusiast

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.

2 REPLIES
Enthusiast

Re: airlines query - cross value duplicate elimination

Is it something like this what was done by Dieter?

http://forums.teradata.com/forum/database/help-on-below-sql#comment-137894

Enthusiast

Re: airlines query - cross value duplicate elimination

Yes. Thanks Raja and Dieter.