i want to calculate sum of TotalCommission by WorkerId

Question

this is my table  I want to find out sum of total commission in this table by worker id show record like this workerid branchid rankid totalcommission 3 4 12 45. 9 4 1 269.00

Jignesh Trivedi · Answer

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 workeridbranchid Rankid hope this will help you.

Sunny Sharma · Answer

Hi Bhupendra Use this query: SELECT workerid MAX(branchid) MAX(rankid) SUM(TotalCommission) FROM GROUP BY workerid Hope it helps :) Please accept this as answer if it helps. Thanks.