Yes, you can do this using CTEs, i.e. WITH clause, pretty much exactly how you s... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

gleb on July 12, 2016 | parent | context | favorite | on: A beginners guide to thinking in SQL

Yes, you can do this using CTEs, i.e. WITH clause, pretty much exactly how you suggest.

Consider applying for YC's Fall 2026 batch! Applications are open till July 27.
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact