0 Replies Latest reply: Nov 5, 2012 5:08 PM by 972040 RSS

    SELECT stmt required to retrieve the output data as specified.

    972040
      source table:

      Origin      Destination      Miles

      Sydney           Melbourne      1000
      Perth           Adelaide      3000
      Canberra      Melbounre      700
      Melbourne      Sydney      1000
      Brisbane      Sydney      1000
      Perth      Darwin      4000
      Sydney      Brisbane      1000

      Duplicate routes are to be ignored so the output is

      out put:


      Origin           Destination      Miles

      Sydney           Melbourne      1000
      Perth           Adelaide      3000
      Canberra      Melbounre      700
      Brisbane      Sydney           1000
      Perth           Darwin           4000

      Please suggest a select query / sub query with out using any subprograms or functions/pkgs to get the out put table.