Subject Aggregate functions request - FIRST() & LAST()
Author Artur Anjos
I don't know if someone has already ask for this, but here we go:

(I really don't know if this is the rigth newsgroup for features
request....)

What I need it's the Aggregate Functions FIRST & LAST to be implemented.

Something like this:

SELECT LAST(DATA) AS LAST_DATA,LAST(EUTOTAL) AS LAST_VALUE FROM RECIBOS_MST
WHERE CLIENTE=:Cliente AND EMPRESA=:Empresa
GROUP BY CLIENTE, EMPRESA
ORDER BY DATA

This will bring us a nice way to get the FIRST & LAST values of a Select.

(Now I'm using a 'turn around' like:
SELECT FIRST 1 DATA AS LAST_DATA,EUTOTAL AS LAST_VALUE FROM RECIBOS_MST
WHERE CLIENTE=:Cliente AND EMPRESA=:Empresa
ORDER BY DATA DESC

Artur