Tutorialsteacher

Follow Us

Articles
  • C#
  • C# OOP
  • ASP.NET Core
  • ASP.NET MVC
  • LINQ
  • Inversion of Control (IoC)
  • Web API
  • JavaScript
  • TypeScript
  • jQuery
  • Angular 11
  • Node.js
  • D3.js
  • Sass
  • Python
  • Go lang
  • HTTPS (SSL)
  • Regex
  • SQL
  • SQL Server
  • PostgreSQL
  • MongoDB
  • SQL Server - Get Started
  • Install SQL Server
  • SQL Server Management Studio
  • SQL Server - Windows Authentication
  • SQL Server - Authentication
  • SQL Server - Create New User
  • SQL Server - GRANT/REVOKE Permissions to User
  • SQL Server - Data Types
  • SQL Server - Naming Conventions
  • SQL Server - CREATE Database
  • SQL Server - CREATE Table
  • Add Columns
  • Identity Column
  • Rename Column, Table
  • Drop Columns
  • SQL Server - Schema
  • SQL Server - Tables Relations
  • SQL Server - Primary Keys
  • Modify/Delete Primary Keys
  • SQL Server - Foreign Keys
  • Modify/Delete Foreign Keys
  • SQL Server - Check Constraints
  • SQL Server - Unique Constraints
  • SQL Server - Views
  • Modify/Delete Views
  • SQL Server - Functions
  • SQL Server - Stored Procedures
  • Stored Procedure Parameters
  • SQL Server - Indexes
  • Non-clustered Indexes
  • Modify/Delete Indexes
  • SQL Server - Triggers
  • DDL Triggers
  • LOGON Triggers
  • Enable/Disable Triggers
  • Modify/Delete Triggers
  • SQL Server - Sequence
  • SQL Server - Synonyms
  • SQL Server - IF ELSE Statement
  • SQL Server - Loops
  • SQL Server - Insert Data
  • SQL Server - Update Data
  • SQL Server - Delete Data
  • SQL Server - Select Query
  • WHERE Clause
  • GROUP BY Clause
  • HAVING Clause
  • ORDER BY Clause
  • SQL Server - Inner Join
  • Left Join
  • Right Join
  • Full Join
  • Self Join
  • Dynamic SQL
  • Built-in Functions
Entity Framework Extensions - Boost EF Core 9
  Bulk Insert
  Bulk Delete
  Bulk Update
  Bulk Merge

SQL Server MAX(): Get Maximum Value in a Column

In SQL Server, the MAX() function is an aggregate function that returns the maximum value in the column or expression.

It is an aggregate function so it canbe used with the GROUP BY clause to find the maximum value in a group.

MAX(expression)

Parameters

expression: It can be a constant, a table column, or function, and any combination of arithmetic, or string operators.

MAX can be used with numeric, character, uniqueidentifier, or with datetime data.

Return Value

Returns the maximum value in the group of the same data type. It ignores the NULL values.

Get Maximum Value in the Column

The following query fetches the maximum Salary from the Employee table.

Example: MAX()
SELECT MAX(Salary) AS MaxSal FROM Employee;

To check the above result, use the following query to fetch all records from the Employee table ordered by Salary in ascending order.

SELECT * FROM Employee ORDER BY Salary;

As you can see, the maximum Salary in the Employee is 200000.

MAX() with String Column

The MAX() function can be used on the string column. For example, the following uses the MAX() function on the LastName column of the Employee table. It will sort the column alphabetically and the last value will be returned.

Example: MAX()
SELECT MAX(LastName) FROM Employee;

Above, 'Troy' is the last value alphabetically and so it will be returned.

MAX() with GROUP BY Clause

In the following example, the maximum salary for each department is returned by using the GROUP BY clause. Here the GROUP BY clause groups the employees based on their department and then the maximum salary in each group is returned.

Example: MAX() with Group By
SELECT DepartmentId, MAX(Salary) AS DeptMaxSalary
        FROM Employee
        GROUP BY DepartmentId;

MAX() with HAVING Clause

The MAX() function can be used with the HAVING clause as shown in the below example. Here the GROUP BY clause groups the employees according to their departments, gets the maximum salary of each department, and then the HAVING clause filters the result by returning only those departments having a maximum salary greater than 50000.

Example: MAX() with Having Clause
SELECT DepartmentId, Max(Salary) DeptMaxSal FROM Employee
        GROUP BY DepartmentID
        HAVING MAX (Salary) > 50000;

Get Maximum and Minimum Value

In the following example, the MIN() and MAX() functions are used on the Salary column of the Employee table. The minimum and maximum salary in the table is returned.

Example: MIN() and MAX()
SELECT MIN(Salary) AS MinSal, MAX(Salary) AS MaxSal FROM Employee;
TUTORIALSTEACHER.COM

TutorialsTeacher.com is your authoritative source for comprehensive technologies tutorials, tailored to guide you through mastering various web and other technologies through a step-by-step approach.

Our content helps you to learn technologies easily and quickly for learners of all levels. By accessing this platform, you acknowledge that you have reviewed and consented to abide by our Terms of Use and Privacy Policy, designed to safeguard your experience and privacy rights.

[email protected]

ABOUT USTERMS OF USEPRIVACY POLICY
copywrite-symbol

2024 TutorialsTeacher.com. (v 1.2) All Rights Reserved.