5 Replies Latest reply: Nov 7, 2012 6:01 PM by 972756 RSS

    Can Anyone help to suggest the query

    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.