First() and Last()Function in MS Access

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
My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.


Article Tags :
Practice Tags :


Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.