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



  
  • [firebird-support... Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
    • Re: [firebir... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
      • Re: [fir... Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
        • Re: ... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
      • Re: [fir... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
    • [firebird-su... hv...@users.sourceforge.net [firebird-support]

Reply via email to