firstLast

FIRST and LAST: the value on the earliest or latest record of a group by an ordering field.