Subject Re: [firebird-support] last of the SQL
Author Mark Rotteveel
Ismael L. Donis Garc?a wrote:
> What show substitutes the show last of the SQL?
> Example: select, last(staff.address) as address from staff group
> by order by

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

Mark Rotteveel