i want to calculate sum of TotalCommission by WorkerId

hi,

here i have some query...
you want to sum of Total Commission by Worker Id wise Or
Worker Id, RankId, BranchId wise?

Try following Query it give you a sum of Total Commission by Worker Id, RankId, BranchId wise
SELECT workerid, branchid, Rankid, SUM(TotalCommission)
FROM #tablename> GROUP BY workerid,branchid, Rankid

hope this will help you.