Open In App

First() and Last()Function in MS Access

Improve
Improve
Improve
Like Article
Like
Save Article
Save
Share
Report issue
Report

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

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