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