SQL Server Aggregate Functions: MIN

What is the MIN Function?

The MIN function returns the smallest value from a set of values in a specified column or expression.

It can be used to find the lowest number, earliest date, or alphabetically smallest string in a dataset.

• Syntax: MIN(column_name)
• Returns a single value representing the minimum.
• Ignores NULL values in the calculation.

Syntax and Usage

The basic syntax for the MIN function is straightforward.

You can use it in SELECT statements with or without GROUP BY.

• SELECT MIN(column_name) FROM table_name;
• SELECT column_group, MIN(column_name) FROM table_name GROUP BY column_group;

Examples of MIN Function

Here are practical examples demonstrating how to use MIN in SQL Server.

Best Practices When Using MIN

Following best practices ensures your queries using MIN are efficient and accurate.

• Always handle NULL values appropriately; MIN ignores NULLs by default.
• Use GROUP BY when you need minimum values per category or group.
• Index columns used in MIN queries for better performance on large datasets.
• Avoid using MIN on expressions that may cause unexpected results without testing.

Common Mistakes to Avoid

Be aware of common pitfalls when using the MIN function.

• Expecting MIN to return multiple rows; it returns a single minimum value per group or entire set.
• Including NULL values without understanding they are ignored by MIN.
• Using MIN without GROUP BY when grouping is needed, leading to incorrect results.
• Applying MIN on incompatible data types without casting.