The TSQL MIN function is used to return the minimum value of an expression in a SELECT
statement.
The syntax for the TSQL MIN function is:
MAX with TSQL GROUP BY
In some cases, you will be required to use the TSQL GROUP BY clause with
the TSQL MIN function.
The syntax for the TSQL MIN function is:
SELECT MIN(expression)
FROM tables
WHERE conditions;
The most simple ways to see example is to get minimum value for a particular
column. In below example its Employee table which has Salary column and we want
min value in this column.
SELECT MIN(salary) AS "Lowest salary"
FROM employees;
MAX with TSQL GROUP BY
In some cases, you will be required to use the TSQL GROUP BY clause with
the TSQL MIN function.
For example, you could also use the TSQL MIN function to return the name
of each department and the minimum salary in the department.
SELECT department, MIN (salary) AS "Lowest salary"
FROM employees
GROUP BY department;
Because you have listed one column in your TSQL SELECT statement that is not encapsulated in the TSQL MIN function, you must use the TSQL GROUP BY clause. The department field must, therefore, be listed in the GROUP BY
section.
No comments:
Post a Comment