Open In App

Abs() and Avg() Function in MS Access

Improve
Improve
Like Article
Like
Save
Share
Report

1. Abs() Function :
In MS Access, the abs() function returns a positive (absolute) number. In this function, either a positive number or a negative number is passed, and it returns the absolute of that number. It takes a number as a parameter and it returns the positive value of that number.

Syntax :

Abs(number)

Example –

SELECT Abs(-240.7) AS AbsNum;

Output –

AbsNum
240.7

Example –

SELECT Abs(120.89) AS AbsNum;

Output –

AbsNum
120.89



2. Avg() Function :
In MS Access, the Avg() function is used for calculating the average of the numbers. In this function, a set of numbers/expression is passed and it returns the average of the input numbers.

Note –
If the null values are given then it will be ignored.

Syntax :

Avg(expression)

Table – Stu_Details

TESTID USERNAME MARKS
101 GFG_1 47
102 GFG_2 78
103 GFG_3 67

Example-1:

SELECT Avg(MARKS) AS Average 
FROM Stu_Details;

Output –

Average
64

Example-2:

SELECT * 
FROM Stu_Details
WHERE MARKS > (SELECT Avg(MARKS) FROM Stu_Details);

Output –

TESTID USERNAME MARKS
102 GFG_2 78
103 GFG_3 67

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