with source_table (sender, receiver, message_time) as ( select 1, 2, to_date('01.01.2020 20:00:00', 'dd.mm.yyyy hh24:mi:ss') from dual union all select 2, 1, to_date('01.01.2020 21:00:00', 'dd.mm.yyyy hh24:mi:ss') from dual) select * from source_table