在存储过程中使用Group By子句

I have a storedprocedure in which iam getting InvoiceValue as one field.I have different invoice values corresponding to 1 fileid.I want to get the sum of invoice values corresponding to each fileid.How can i use group by here? here is my stored procedureI have a storedprocedure in which iam getting I