select RequestNo,FileName,PaymentStatus,count(0) as TxnCount,SUM(PaidAmount) as Amount ,SUM(SUM(PaidAmount)) over(Order by RequestNo) as RunningSum from Tbl_T_CommunityPaymentOnline where IsDeleted is null and RequestNo>=131 and PaymentStatus='Inprocess' group by RequestNo,PaymentStatus,FileName
Comments
Post a Comment