By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select random() as rnd union all
select random() as rnd
| rnd |
|---|
| 4865739885880678000 |
| 7043813893986921000 |
WITH
test_a as ( select random() ),
test_b as ( select * from test_a )
select * from test_a
union all
select * from test_b
| random() |
|---|
| -5516896696497172000 |
| -5516896696497172000 |