SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table table_name (
  session_id int,
  item text)
✓
insert into table_name values 
(1,	't-shirt'),
(1,	'trousers'),
(1,	'hat'),
(2,	'belt'),
(2,	'shoes')
✓
select a.session_id,
       a.item item_a,
       b.item item_b
from table_name a join table_name b
on a.session_id = b.session_id
   and a.item > b.item
order by a.session_id, a.item 


session_id
item_a
item_b


1
t-shirt
hat

1
trousers
hat

1
trousers
t-shirt

2
shoes
belt