Hi,
Please help to form the query for the below expected results. working on 19c version. I have given sample table ,data & expected results.
create table Author (
id number not null,
name varchar2(30) not null
);
insert into Author values (1, 'jai');
insert into Author values (2, 'Ritesh');
insert into Author values (3, 'Kaarki');
insert into Author values (4, 'Sindhu');
insert into Author values (6, 'Liver');
commit;
id | name
---------+----------------
1 | jai
2 | Ritesh
3 | Kaarki
4 | Sindhu
6 | Liver
expected results as below
left_name | right_name
------------+----------------
NULL | jai
Ritesh | Kaarki
Sindhu | NULL
Liver | NULL