How to assign a variable in select statement

Question

I have Some filedvalues say OpeningWtSalesDetails and Balance fro differwnt table select opWt.OpeningWt as OpeningWt sales.SalesDetails as SalesDetails  opWt.OpeningWt-sale.SalesDetails as Balance from sales inner join opWt on opWt.id=sales .id This is sample query for selecting values. I got balance  this balance assign to openingwt for next row How assign in select statement this type of answer i required OpenigWt SalesDetails Balance 0 5 5 5 8 -3 -3 9 -12 I think any loop can use? i dont know how to use.. pls help me

Suthish Nair · Answer

Ok you have changed the query. If am not wrong you want the closing balance to be the opening balance of next row? refer thread: Save previous row value to next row..

Muralidharan Deenathayalan · Answer

I don't think CTE is really required here. You can try this way also select sales.OpeningWt as OpeningWt sales.SalesDetails as SalesDetails sales.OpeningWt-sale.SalesDetails as Balance from sales

Suthish Nair · Answer

with cte as ( select sales.OpeningWt as OpeningWt  sales.SalesDetails as SalesDetails  sales.OpeningWt-sale.SalesDetails as Balance from sales ) select * from cte