Subject Re: [IB-Architect] Aggregate functions request - FIRST() & LAST()
Author Fabricio Araujo
In general, IB-Priorities (now changed the name to Firebird-Priorities)
is the place to go to request. Here is for planning details of implementation

[]s Fabricio

On Wed, 20 Feb 2002 00:21:40 -0000, Artur Anjos wrote:

>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
>
>
>
>To unsubscribe from this group, send an email to:
>IB-Architect-unsubscribe@onelist.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>


[]s Fabricio
Systems Developer