Simon Willison’s Weblog

Subscribe

Thursday, 3rd October 2019

SQL queries don’t start with SELECT. This is really useful. Understanding that SELECT (and associated window functions) happen after the WHERE, GROUP BY and HAVING helps explain why you can’t filter a query based on the results of a window function for example.

# 8:56 pm / sql, julia-evans

2019 » October

MTWTFSS
 123456
78910111213
14151617181920
21222324252627
28293031