GitHub

sql_cte_tutorial_version2.html

.hint-area.hint { background: var(--orange-bg); color: var(--orange); } .hint-area.success { background: var(--green-bg); color: var(--green); } .hint-area.error ...
LinkedIn

Zi Yang Lin’s Post

🧵 Published a comprehensive guide to SQL Recursion with PostgreSQL! Ever struggled with hierarchical data? Whether it's organizational charts, product categories, or file systems, SQL recursion with ...
GitHub

sql_cte_tutorial.html

.hint-area.hint { background: var(--orange-bg); color: var(--orange); } .hint-area.success { background: var(--green-bg); color: var(--green); } .hint-area.error ...
LinkedIn

Subquery vs CTE in SQL: Key Differences

🚀 Subquery vs CTE in SQL — What’s the Difference? If you work with SQL, you’ve probably used both Subqueries and CTEs (Common Table Expressions). While they can often solve similar problems, they ...