Need query for this

Database
Enthusiast

Need query for this

I/p:

SRC     DESTN      DIST

HYD     BNG       700

BNG    HYD       700

BNG    CHN      400

O/p:

SRC      DESTN    DIST

HYD     BNG         700

BNG    CHN         400

1 REPLY
Enthusiast

Re: Need query for this

Can you give more details please?  if it is in the same table you can do a delete.