By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select rand() as rnd union all
select rand() as rnd
| rnd |
|---|
| 0.0014175088531201 |
| 0.522054389378644 |
WITH
test_a as ( select rand() as rnd ),
test_b as ( select * from test_a )
select * from test_a
union all
select * from test_b
| rnd |
|---|
| 0.160377090511521 |
| 0.276885005741768 |