Wildcard tables in BigQuery
Imagine you have multiple tables that have similar structure and contain data for different time periods (or different locations). You want… Keep reading .
Small Things SQL
Short articles exploring topics in SQL.
Latest posts
Inline functions in Oracle queries
Defining common table expressions (CTEs) using the WITH clause in SQL queries is a fairly common practice. Oracle has allowed creating… Keep reading .
500x improvement using Group By Cube and Having (Oracle)
Understanding how the group by and having clauses work can help us write more efficient SQL. I want to demonstrate this with an example… Keep reading .