For more information, please refer to this announcement explaining best practices for getting answers to questions.
Using SUM function in Table Type Value set using FF
Summary:
Unable to get the sum function in table value set and how we need to get these values in query?
Content (required):
Here i am facing multiple rows for each different record type, how to get these records in sum function
FOR EX:
SH TM_REC_ID
-----------------------------------
10 300000007706123
20 300000007706456
30 300000007706789
i need total sum for '60' and how we can get these values ?
pls help me on this.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
SELECT A.SH, A.TM_REC_ID
FROM
(SELECT SUM(HOURS) SH, TM_REC_ID