SELECT  SumBal.Userid, SumBal.UserTransnumber,SumBal.moduleid, SumBal.clientid  ,
        SumBal.ChangeAmount , bl.FinalBalance, bl.SessionID, bl.[Time], bl.EventID, bl.RowID 
FROM ( SELECT  Userid, UserTransnumber,Moduleid, Clientid ,SUM(ChangeAmt) ChangeAmount 
        FROM tb_BalanceLog
        WHERE UserID = @UserID AND RowID BETWEEN @MinRowID AND @MaxRowID
        GROUP BY Userid, UserTransnumber,Moduleid, Clientid  
      ) SumBal
JOIN tb_BalanceLog bl 
ON  SumBal.Userid = bl.UserID 
AND SumBal.UserTransnumber = bl.UserTransNumber 
JOIN (
      SELECT UserID, UserTransnumber,MAX(rowid) RowID 
      FROM tb_Balancelog 
      WHERE userid = @UserID AND RowID BETWEEN @MinRowID AND @MaxRowID
      GROUP BY UserID, UserTransnumber
      ) BalRow 
ON bl.UserID = BalRow.UserID AND bl.RowID = BalRow.RowID