3 ms·Yes, you can do this using CTEs, i.e. WITH clause, pretty much exactly how you suggest.by gleb 10y agoYes, you can do this using CTEs, i.e. WITH clause, pretty much exactly how you suggest.