Constantin Lungudatawise.devยทOct 20, 2024Another look at ANY_VALUE in BigQueryA reminder that ANY_VALUE is a pretty interesting aggregation function in BigQuery SQL. It gives you a chosen row from a group. Chosen doesn't mean random, but non-deterministic. Together with HAVING MAX | MIN you can actually control what rows get p...31 readsPractical SQLbigqueryAdd a thoughtful commentNo comments yetBe the first to start the conversation.
