Hallo,

Il 07/03/2016 11.32, Dimitry Sibiryakov [email protected] 
[firebird-support] ha scritto:
> sum(saldo) over (order by data) 

Thank You for your response but I can't do: sum(SALDO) because SALDO is 
not a field of my table.

I badly explained myself: I have a table with only this fields:

DATA     DOCUMENTO_ID   NUMERO   SERIE  CARICO   SCARICO


I need add SALDO fields in the result of the query to get a progressive 
sum of CARICO - SCARICO.

Thanks

-- 

Luigi Siciliano
--------------------------



------------------------------------

------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-support/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo Groups is subject to:
    https://info.yahoo.com/legal/us/yahoo/utos/terms/

Reply via email to