Fun with SQL: Recursive CTEs in PostgresFun with SQL: Recursive CTEs in Postgres Written by Craig Kerstiens May 15, 2018 Common Table Expressions (CTEs) are a powerful construct within SQL. In day to day conversation, you may hear CTEs referred to as WITH clauses. You can think of CTEs as similar to a view that is materialized only while that query is running and does not exist outside of that query. CTEs can be very useful building blo
SQLアンチパターンon Rails Ⅰ部（論理設計） - Qiita
