Subject | Re: [IB-Architect] Aggregate functions request - FIRST() & LAST() |
---|---|
Author | Fabricio Araujo |
Post date | 2002-02-22T04:50:31Z |
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
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