By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH yourTable AS (
SELECT 1 AS session_id, 'A' AS page_viewed UNION ALL
SELECT 1, 'B' UNION ALL
SELECT 1, 'C' UNION ALL
SELECT 2, 'B' UNION ALL
SELECT 2, 'E'
)
SELECT
t1.session_id,
t1.page_viewed AS page_1,
t2.page_viewed AS page_2
FROM yourTable t1
INNER JOIN yourTable t2
ON t1.session_id = t2.session_id;
| session_id | page_1 | page_2 |
|---|---|---|
| 1 | A | A |
| 1 | A | B |
| 1 | A | C |
| 1 | B | A |
| 1 | B | B |
| 1 | B | C |
| 1 | C | A |
| 1 | C | B |
| 1 | C | C |
| 2 | B | B |
| 2 | B | E |
| 2 | E | B |
| 2 | E | E |