want to add one more column in my Sql server query -

want to add one more column in my Sql server query -

i using query result

select t.accode,t.acname, sum(t.debit)as debit, sum(t.credit) credit transactions t inner bring together accounts on a.code = t.accode a.typecode = 5 , t.date between '2014-05-01' , '2014-05-15' grouping t.accode,t.acname

i getting result query

accode acname debit credit 1 umer 200 300

now want add together previos balance column in result. sample query is

sum(debit)-sum(credit) previousbalance transaction date < '2014-05-01'

and result this

accode acname previousbalance debit credit 1 umer 50 200 300

can 1 please tell me how ? shall thankful you.

you can insert subquery in select statement this:

select t.accode,t.acname, sum(t.debit)as debit, sum(t.credit) credit , (select sum(t2.debit) - sum(t2.credit) transactions t2 inner bring together accounts a2 on t2.accode = a2.code a2.code = t.accode , t2.date < '2014-05-01') prevbalance transactions t inner bring together accounts on a.code = t.accode a.typecode = 5 , t.date between '2014-05-01' , '2014-05-15' grouping t.accode,t.acname

you might need grouping in subquery, not sure that.

sql sql-server sql-server-2012