Syntax
GROUPLAST(<any>; order by any)
Description
This function returns a value in a group as specified by the ordered column's last value.
- If the column used to order the group is a number, then the value used from the order column is the highest number.
- If the column used to order the group is a string, then the value used from the order column is a lowercase letter starting with z and moving reverse alphabetically followed by uppercase letters reverse alphabetically. If no letters are present in the sting type, the value used is the highest number.
- If the column used to order the group is a date, then the value used from the order column is the latest date.
...