First, Last Functions Example

This example uses the Employees table to return the values from the LastName field of the first and last records returned from the table.

SELECT First(LastName) as First,
Last(LastName) as Last 
FROM Employees;)

The next example compares using the First and Last functions with simply using the Min and Max functions to find the earliest and latest birth dates of Employees.

SELECT First(BirthDate) as FirstBD, 
Last(BirthDate) as LastBD 
FROM Employees;")

SELECT Min(BirthDate) as MinBD,
Max(BirthDate) as MaxBD 
FROM Employees;