Subject Re: [firebird-support] Getting Group By subtracting total for every record in the group
Author Dimitry Sibiryakov
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,
Card_Cat)"


--
WBR, SD.