CREATE TABLE tablename (RESERVATION int, PREFIX varchar2(2), FLIGHT int, ORIGIN varchar2(3), DESTINATION varchar2(3), DATE_FLIGHT timestamp) ;

INSERT ALL INTO tablename (RESERVATION, PREFIX, FLIGHT, ORIGIN, DESTINATION, DATE_FLIGHT) VALUES (111, 'LA', 123, 'LAX', 'MIA', '01-Feb-2020 12:00:00 AM') INTO tablename (RESERVATION, PREFIX, FLIGHT, ORIGIN, DESTINATION, DATE_FLIGHT) VALUES (111, 'LA', 122, 'MIA', 'SCL', '01-Feb-2020 10:30:00 AM') INTO tablename (RESERVATION, PREFIX, FLIGHT, ORIGIN, DESTINATION, DATE_FLIGHT) VALUES (111, 'LA', 667, 'MIA', 'SCL', '03-Feb-2020 02:15:00 PM') INTO tablename (RESERVATION, PREFIX, FLIGHT, ORIGIN, DESTINATION, DATE_FLIGHT) VALUES (111, 'LA', 882, 'SCL', 'ARG', '03-Feb-2020 04:00:00 PM') INTO tablename (RESERVATION, PREFIX, FLIGHT, ORIGIN, DESTINATION, DATE_FLIGHT) VALUES (111, 'LA', 111, 'SCL', 'ARG', '03-Feb-2020 11:00:00 PM') INTO tablename (RESERVATION, PREFIX, FLIGHT, ORIGIN, DESTINATION, DATE_FLIGHT) VALUES (111, 'LA', 966, 'SCL', 'ARG', '03-Feb-2020 11:30:00 PM') INTO tablename (RESERVATION, PREFIX, FLIGHT, ORIGIN, DESTINATION, DATE_FLIGHT) VALUES (111, 'LA', 622, 'SCL', 'ARG', '05-Feb-2020 08:00:00 AM') SELECT * FROM dual ;

select t.RESERVATION, t1.PREFIX PREFIX_min, t1.FLIGHT FLIGHT_min, t1.ORIGIN ORIGIN_min, t1.DESTINATION DESTINATION_min, t1.DATE_FLIGHT DATE_FLIGHT_min, t2.PREFIX PREFIX_max, t2.FLIGHT FLIGHT_max, t2.ORIGIN ORIGIN_max, t2.DESTINATION DESTINATION_max, t2.DATE_FLIGHT DATE_FLIGHT_max from ( select RESERVATION, min(DATE_FLIGHT) DATE_FLIGHT_min, max(DATE_FLIGHT) DATE_FLIGHT_max from tablename group by RESERVATION ) t inner join tablename t1 on t1.RESERVATION = t.RESERVATION AND t1.DATE_FLIGHT = t.DATE_FLIGHT_min inner join tablename t2 on t2.RESERVATION = t.RESERVATION AND t2.DATE_FLIGHT = t.DATE_FLIGHT_max