1. First() Function :
In MS Access, the First() function is used to return a field value from the first record in the result set returned by a query.
Syntax :
First(expr)
Parameter :
- expr : It represents a string expression identifying the field that contains the data we want to use or an expression that performs a calculation using the data in that field.
Returns : It returns the first record in the result set.
Table – Employee_Details
| Emp_id | Emp_Name | Experience |
|---|---|---|
| 101 | Amit | 5 |
| 102 | Rahul | 10 |
| 103 | Suhani | 8 |
Example-1 :
SELECT First(Emp_id) AS EmployeeId FROM Employee_Details;
Output :
| EmployeeId |
|---|
| 101 |
Example-2 :
SELECT First(Emp_Name) AS FirstEmployee FROM Employee_Details;
Output :
| FirstEmployee |
|---|
| Amit |
2. Last() Function :
In MS Access, the Last() function is used to return a field value from the last record in the result set returned by a query.
Syntax :
Last(expr)
Parameter :
- expr : It represents a string expression identifying the field that contains the data we want to use or an expression that performs a calculation using the data in that field.
Returns : It returns the last record in the result set.
Example-2 :
SELECT Last(Emp_id) AS EmployeeId FROM Employee_Details;
Output :
| EmployeeId |
|---|
| 103 |
Example-2 :
SELECT Last(Emp_Name) AS LastEmployee FROM Employee_Details;
Output :
| LastEmployee |
|---|
| Suhani |