Exp() and Count() Function in MS Access
Last Updated :
01 Sep, 2020
1. Exp() function :
In MS Access, the Exp() function returns e( 2.718281) power raised to a number. In this function, a number will be pass as a parameter and it will return e raised to the power of a specified number.e is a constant which value is equal to 2.718281. It is the base of natural logarithms.
Syntax :
Exp(number)
Example-1 :
SELECT Exp(6) AS ExpNum;
Output –
Example-2 :
SELECT Exp(1) AS ExpNum;
Output –
2. Count() function :
In MS Access, The Count() function returns the total number of eligible records of a query. When a query expression is performed with the help of count function then it will count total records and return that total count number.
Note –
Null values will not be included in the count.
Syntax :
Count(expression)
Consider an example for Demo Database given below.
Table name : Stu_Details.
TEST_ID |
USER_ID |
MARKS |
101 |
GFG_1 |
67 |
102 |
GFG_2 |
89 |
103 |
GFG_3 |
35 |
Example-1 :
SELECT Count(*) AS TOTAL FROM Stu_Details;
Output –
Example-2 :
SELECT Count(*) AS TOTAL FROM Stu_Details
Where MARKS>50;
Output –
Share your thoughts in the comments
Please Login to comment...