MIN_BY and MAX_BY Functions in Snowflake
MIN_BY and MAX_BY are aggregate functions in Snowflake that calculate the minimum or maximum value of a column and return the value of another column in that row.
Get Started Today
Recent Posts
HOW TO: Drop a Column from a Snowpark DataFrame?
Learn how to drop a column from a Snowflake Snowpark DataFrame using drop() method with examples.
HOW TO: Add a New Column to a Snowpark DataFrame?
Learn multiple ways to add a new column to a Snowpark DataFrame that includes adding a column with default value, based on a condition, and adding multiple columns with examples.
HOW TO: Remove Duplicates in a Snowpark DataFrame?
The dropDuplicates() method in Snowpark returns a new DataFrame with all duplicate rows removed.
CASE Statement in Snowflake Snowpark
Learn how a CASE statement can be constructed in Snowflake Snowpark using when() and otherwise() methods.
INSERT and Multi-Table Inserts in Snowflake
Learn how to perform Insert, Multi-Row Insert and Multi-Table Inserts in Snowflake using INSERT and INSERT ALL statements.
Take a quick peek into all Course offerings
Automation
Ideas
Best Automation ideas with detailed explanation to implement in IICS Projects
TEST YOUR KNOWLEDGE
Test your knowledge on important various IICS and Snowflake concepts
Interview Preparation
Top Interview Questions to get you prepared before your interview