Re: aggregate function ?

Well, that's perfectly ...

Now I'm going to try to understand how this work ...

In the web page that you refer, it also shows how to do it with a
temporal table/cursor, and I see it's faster there.

You have more options if you need to do some extra operations, but I
see how powerful SQL can be ...

Would be possible with this code to start the sum_value with a
previous value from another SELECT ?

For example, SELECT SUM(deure)-SUM(haver) FROM assentaments WHERE
data<2007-01-01;

thanks again four your help, I really appreciated, really !

regards,

raimon

On 16/05/2007, at 17:45, Richard Broersma Jr wrote:

> If all else fails, look for the answer on google:
> http://www.sqlteam.com/item.asp?ItemID=3856
>
> aparently "ON A1.oid <= A2.oid" should have been:
> "ON A1.oid >= A2.oid".
>
>
> SELECT A1.oid, A1.concepte, A1.deure, A1.haver,
> sum( COALESCE( A2.deure, 0 ) -
> COALESCE( A2.haver, 0 )) AS value_sum
> FROM Assentaments AS A1
> INNER JOIN Assentaments AS A2
> ON A1.oid >= A2.oid
> AND A1.numero = A2.numero
> WHERE A1.numero=11189
> GROUP BY A1.oid, A1.concepte, A1.deure, A1.haver
> ORDER BY A1.oid;
>
>
>
>