Okay, obviously many SQL queries do start with SELECT (and actually this post is only about SELECT queries, not INSERTs or anything). But! Yesterday I was working on an explanation of window functions, and I found myself googling “can you filter based on the result of a window function”. via Pocket

bookmarked in Bascht's Pinboard: https://jvns.ca/blog/2019/10/03/sql-queries-don-t-start-with-select/