Subject Re: [firebird-support] Getting Group By subtracting total for every record in the group
Author Vishal Tiwari
Hi Dimitry,

Thank You for the reply.

Let me check and revert.

With Best Regards.


On Saturday, 19 May, 2018, 8:50:58 PM IST, Dimitry Sibiryakov sd@... [firebird-support] <> wrote:

19.05.2018 17:12, Vishal Tiwari vishualsoft@... [firebird-support] wrote:
> I have below table requirement, where the data should be subtracted for each record in the
> row. For each group subtraction should be separate.

  It looks like you need something like "SUM(In_Val-Out_Val) OVER (GROUP BY Card_No,

  WBR, SD.




Visit 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


Yahoo Groups Links

<*> To visit your group on the web, go to:

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    (Yahoo! ID required)

<*> To change settings via email:

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

<*> Your use of Yahoo Groups is subject to: