Open In App

Max() and Min() function in MS Access

Improve
Improve
Like Article
Like
Save
Share
Report

1. Max() Function :
max() function return the maximum value of given set. In the function a query is passed and in the eligible records which value will be maximum that will return as result. A expression will be pass as parameter and it will return the maximum value in the expression.

Syntax :

Max (expression)

Demo Database for example :

Table name : student

student_id Marks
121 56
122 45
123 89
124 50

Example-1 :

SELECT Max(Marks) AS marks 
FROM student;

Output –

marks
89

Example-2 :

SELECT Max(Marks) AS marks 
FROM student
where Marks<80;

Output –

marks
56

2. Min() Function :
min() function works like max() function but it will return the minimum value of the expression. In this function a query will be passed as parameter and it will return the minimum record.

Syntax :

 Min(expression)

Example-1 :

SELECT Min(Marks) AS marks 
FROM student;

Output –

marks
45

Example-2 :

SELECT Min(Marks) AS marks 
FROM student
where Marks>50;

Output –

marks
56

Last Updated : 02 Sep, 2020
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads