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] <firebird-support@yahoogroups.com> wrote: 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) OVER (GROUP BY Card_No, Card_Cat)" -- WBR, SD. ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 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