Constantin Lungudatawise.dev·Sep 8, 2023Using MAX_BY / MIN_BY in BigQueryJust stumbled upon a nifty SQL function in BigQuery that was new to me. Did you know about MAX_BY / MIN_BY? They're essentially shortcuts for ANY_VALUE(columnA HAVING MIN/MAX(columnB)). And guess what? I had no idea you could use HAVING within ANY_VA...65 readsPractical BigQuerybigqueryAdd a thoughtful commentNo comments yetBe the first to start the conversation.