Subject Re: [firebird-support] Getting Group By subtracting total for every record in the group
Author Vishal Tiwari
Post date 2018-06-07T11:43:41Z
Hi SET, Dimitry,

Below SQL gives error for below SQL:
SELECT a.CARD_NO, a.CARD_CAT, a.IN_VAL, a.OUT_VAL, SUM(In_Val-Out_Val) OVER (GROUP BY Card_No, Card_Cat) 
FROM CARD a


Error:
Engine Code    : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 78
GROUP


Partition and Order BY is not useful to get the expected result as discussed in previous mail.


Kindly suggest.


With Best Regards.

Vishal


On Saturday, 19 May, 2018, 8:50:58 PM IST, Dimitry Sibiryakov sd@... [firebird-support] <firebird-support@yahoogroups.com> 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,
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

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-support/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-support-digest@yahoogroups.com
    firebird-support-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    firebird-support-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
    https://info.yahoo.com/legal/us/yahoo/utos/terms/