SQL Server MIN() function is an aggregate function that is used to find the smallest or minimum value of a column.
If a table have only single value then the minimum value will be a value itself.
If all values in a table are same then the minimum value will be a value itself.
Syntax
MIN ( columnname )
Lets look at an example of MIN function in SQL Server.
Here we have a EMPLOYEE table named as EMP.
CREATE TABLE dbo.EMP ( EMPID INT NOT NULL, EMP_DEPT VARCHAR(50), EMP_NAME VARCHAR(50), EMP_SALARY NUMERIC(9,2) ) INSERT INTO dbo.EMP (EMPID, EMP_DEPT, EMP_NAME, EMP_SALARY) VALUES (101, 'PRODUCTION', 'RAJAT M',75000.00), (102, 'PRODUCTION', 'MUKESH BHATIA',70000.00), (103, 'PRODUCTION', 'MUSKAN MEHTA',75000.00), (104, 'SALES', 'ROHAN B NARAYA',45000.00), (105, 'SALES', 'SUSHIL DAS',40000.00), (106, 'SALES', 'MANISH',45000.00), (107, 'PRODUCTION', 'RAJESH SINGH',78000.00), (108, 'HR', 'MOHIN KHAN',50000.00), (109, 'HR', 'SUSHANT K SINGH',55000.00), (110, 'HR', 'LAKSHYA RAWAT',55000.00), (111, 'PRODUCTION', 'MANOJ KUMAR',75000.00), (112, 'SALES', 'SUJOY M',40000.00), (113, 'LOGISTIC', 'VINAY AGARWAL',35000.00), (114, 'LOGISTIC','MUSTAKIM M',35000.00), (115, 'LOGISTIC', 'VIJAY KUMAWAT',45000.00)
To get the lowest salary in the entire table
SELECT MIN(EMP_SALARY) AS MIN_SAL FROM dbo.EMP
Get the Lowest salary that is given to employees in each DEPARTMENT
SELECT EMP_DEPT, MIN(EMP_SALARY) AS MIN_SAL FROM dbo.EMP GROUP BY EMP_DEPT
Get the Lowest paid salary for PRODUCTION Department
SELECT MIN(EMP_SALARY) AS MIN_SAL FROM dbo.EMP WHERE EMP_DEPT = 'PRODUCTION'
Get the Lowest paid salary in each department that should be less than 50000
SELECT EMP_DEPT, MIN(EMP_SALARY) AS MIN_SAL FROM dbo.EMP GROUP BY EMP_DEPT HAVING MIN(EMP_SALARY) < 50000
863 total views, 1 views today