Abs() and Avg() Function in MS Access
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 –
Example –
SELECT Abs(120.89) AS AbsNum;
Output –
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 –
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
Share your thoughts in the comments
Please Login to comment...