$ blog / tag
#sql
7 posts
-
The ClickHouse Array Functions You'll Actually Reach For: has, arrayMap, multiIf →
-
count(*) vs count(col): It Comes Down to NULL →
-
Cross-Engine Query Exercises: Test Yourself (With Answers) →
-
One Operation, Many Engines: A Cross-Engine Query Mental Model →
-
LIKE vs ILIKE: Substring Search (and Case) Across SQL Engines →
-
The Portable SQL Core: The 80% That Runs Anywhere →
-
Spark Array Functions & collect_list vs collect_set →