Return the first value from the result set of a query. (SQL).

      First (expression)

   expression   The value/column to return.

The First and Last functions are analogous to the MoveFirst and MoveLast methods of a DAO Recordset object. They simply return the value of a specified field in the first or last record, respectively, of the result set returned by a query.

The First() function can be used in a Group By (Aggregate) SQL query.

First Function

This will return, for each surname the largest and smallest StaffID for the people with that surname.


Select First(sales_id) 
from T_Sales 
Group By Department;

“Winning takes talent; to repeat takes character.” ~ John Wooden


Last - Return the last value from a query.

© Copyright 1999-2016
Some rights reserved