SQL MIN Function

By: Kris Wenzel   |   Updated: March 6, 2022  
Works With: Summarizing Data

The SQL MIN function returns the smallest value within a table or group.  Throughout this section we’ll use the HumanResource.Employee table for our examples: 

Using the data above, MIN calculates the smallest SickLeaveHours amount for the entire table:

When used with GROUP BY, MIN returns the largest value within a group.  Here is a similar query showing the minimum SickLeaveHours by JobTitle: 

Additional SQL MIN Resources  

To learn more, check out these useful resources: 

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}