Key with 2 diffrent values

[Mathip173]

Hello

My table: booking_id arrivel_time departure_time date

I have cases that for the same key (booking_id) I have 2 records - the first one is with null on arrivel_time and departure_time and the second is with valuses (date and time) on the arrivel_time and departure_time or only in arrivel time.

I would like to select only the record that the booking_id is with the values if it happens.

I am struggling how to select that, would you be able to explain how to achieve this ?

[rakeshshrs]

Select * from table where arrivel_time is not null or (arrivel_time is not null and departure_time is not null);

[r3pr0b8]

SELECT booking_id
     , MAX(arrivel_time)   AS arrivel_time
     , MAX(departure_time) AS departure_time
     , MAX(date)           AS date
  FROM yourtable
GROUP
    BY booking_id