Insights

Explore our latest thinking on modern data analytics, advancements in technology, and what you might not know about data.

Insights

New Year, New Functions: MIN_BY / MAX_BY

2/1/2023
DAS42 Image
Christopher Cannon
With the new MIN_BY and MAX_BY functions, you can quickly return the value(s) in one column conditionally based on another column's maximum or minimum value. Answering this question has always been possible with often complicated subqueries, but with this recent Snowflake release, we get a clean function that performs the same task with much less code.
DAS42 Image

Filter by Type

Use Cases

Get our Newsletter

DAS42 Image

Upcoming Events

Come meet our team and get to know us at a gathering near you.

Ready to talk about your data needs?

Contact us to start building a data culture.