Re: [firebird-support] Getting Group By subtracting total for every record in the group

07.06.2018 13:43, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: > Partition and Order BY is not useful to get the expected result as discussed > in previous mail. On contrary, partition AND order by is exactly what you need. Read documentation that Vlad suggested. --

Re: [firebird-support] Getting Group By subtracting total for every record in the group

04.06.2018 8:22, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: > So even after trying as you suggested, can't able to get the result as shown > below: What exactly you tried and what you got? -- WBR, SD.

Re: [firebird-support] Getting Group By subtracting total for every record in the group

Hi Dimitry, Thank You for the reply. Let me check and revert. With Best Regards. Vishal On Saturday, 19 May, 2018, 8:50:58 PM IST, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 19.05.2018 17:12, Vishal Tiwari vishuals...@yahoo.co.in

Re: [firebird-support] Getting Group By subtracting total for every record in the group

19.05.2018 17:12, Vishal Tiwari vishuals...@yahoo.co.in [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)

[firebird-support] Getting Group By subtracting total for every record in the group

Hi All, I have below table requirement, where the data should be subtracted for each record in the row. For each group subtraction should be separate. Kindly find below example. At start of each new group total remain must be zero(group by Card_no and Card_cat) Card_NoCard_CatIn_Val