asterisk-solid All courses are temporarily held live online with an extended free retake period. Learn More.

window-close-line
Hero image for SQL MIN Tutorial

SQL MIN Tutorial

SQL Tutorial: MIN Function

Learn the basics of the MIN function and how and when to use it in this tutorial.

MIN Function

  • The MIN function is used to find the minimum value of a given column.

  • It retrieves the minimum value of a given column from our data. 

  • Syntax: SELECT MIN(column_1) FROM table ;

Example

Let’s say we have a basketball league and we keep records of each player, which team they are on, and their basic statistics. 

Stats Table

If we wanted to use a SQL query to find the player with the least assists, we would write the following:

SQL MIN statement

Once we hit enter and run, our result should be as follows:

SQL MIN Result

Master SQL in hands-on training