MIN_BY and MAX_BY in Snowflake: One Line Instead of a Window Function
Share

They replace the QUALIFY ROW_NUMBER() dance with a single call. They also hand back three different kinds of NULL and an arbitrary winner…

 

 They replace the QUALIFY ROW_NUMBER() dance with a single call. They also hand back three different kinds of NULL and an arbitrary winner…Continue reading on Medium » Read More Sql on Medium 

#sql

By ali

Leave a Reply