Dup Flight Sch Query ARRIVALS.sql

  SELECT *
  FROM (SELECT fscode,
               flight_no,
               operator_cd,
               dep_time,
               dest_time,
               dep_location,
               dest_location,
               valid_from,
               valid_to,
               entered_dt,
           ENTERED_BY,
               ROW_NUMBER() OVER(PARTITION BY FLIGHT_NO ORDER BY FLIGHT_NO) rn
          FROM TC_FLIGHTSCHEDULE_MT mt
         WHERE status = 'A' and DEST_LOCATION='VOHY' AND FLIGHT_NO IS NOT NULL) WHERE RN>1