Posts in sql

What the SQL?!? WINDOW

Today’s “What the SQL?!?” features the keyword WINDOW. This clause allows us to elegantly select results from the previous results from the previous results from the previous results…

written in sql, talk Read on →

What the SQL?!? Recursive

Today’s “What the SQL?!?” features the keyword RECURSIVE. This clause allows us to elegantly select results from the previous results from the previous results from the previous results…

written in sql, talk Read on →

What the SQL?!? Lateral Joins

Today’s “What the SQL?!?” features the keyword LATERAL. A prerequisite to understanding lateral joins are regular joins and subqueries. I’ll explain those briefly to see how LATERAL can simplify a complicated SQL query.

written in sql, talk Read on →