Ismael L. Donis Garc?a wrote:

> What show substitutes the show last of the SQL?
>
> Example: select staff.name, last(staff.address) as address from staff group
> by staff.name order by staff.name

You are not being very clear, but I think you want the latest address of
an employee. Since there is no ordering in SQL what you want is not
directly possible with plain SQL. You will need to add an ordering
yourself (eg by adding a date column, or another indication of order or
history).


--
Mark Rotteveel