MIN (SQL) Contents Description Arguments Examples See Also A window function that assigns the minimum value of the field column within the specified window frame to all rows in that window frame. Synopsis MIN(field) Description MIN assigns the minimum value specified by the field column to all rows within the window frame. MIN supports the ROWS clause. Arguments field A column that specifies from where to take the minimum value. Examples The following example compares each employee's salary against the lowest salary earned by an employee within that employee's department: SELECT MIN(Salary) OVER (PARTITION BY Department) FROM Company.Employee See Also Window functions overview Aggregate functions: MIN FeedbackOpens in a new tab
