3 ms·CTEs can do that, but it is quite clunky for when you just want to reuse a partial per row computation.by jeltz 6y agoCTEs can do that, but it is quite clunky for when you just want to reuse a partial per row computation.