Elektrine lite

← Feed

@ham_jansen@mastodon.online

2026-03-31 14:44 UTC

SQL subqueries are confusing until you realize they're just helper functions. In Python, when you need an intermediate result, you write a helper function. In SQL, you nest a query inside another query. Same idea, different syntax. This week's SQL for Python Developers post covers the three types of subqueries , where they can appear in your SQL, and the difference between correlated and non-correlated subqueries. https://jamalhansen.com/blog/subqueries-when-sql-needs-helper-functions #SQL #Python #DuckDB #Programming

Replies (0)

No replies.