I have Made Query For you:
select cast(count(custid) as varchar(5)) + custid [custid],custname,[address],mobileno,investmentdate,investmentamt,agentid,agname,payoutamt,branch,payoutdate,modeofpay
FROM investments
group by custid,custname,[address],mobileno,investmentdate,investmentamt,agentid,agname,payoutamt,branch,payoutdate,modeofpay