Yes that's correct Chris..

SELECT
COL1, Col2, Col3, First_Bal, First_Qty, S_Balance
, First_bal - S_Balance AS New_Balance
FROM (
SELECT COL1, Col2, Col3, SUM(Balance)...

adding ALIAS NAME for a derived table.

SELECT
COL1, Col2, Col3, First_Bal, First_Qty, S_Balance
, First_bal - S_Balance AS New_Balance
FROM (
    SELECT COL1, Col2, Col3, SUM(Balance)...

Thanks a lot Jeff for such an exploring content though you had understood the problem definition incorrect which helped us in different way..
Thanks

Please post DDL and DML statements for the above table structure. so that it would be easy for others to address you.

Thanks a lot Eirik for the reply.
Thom i have updated the solution part for the  clear readability purpose.

Thanks Steve for the valuable suggestions.
I will try to implement the same.

Thank you all for the suggestions.
Thank you John ,Luis, Patrick, Scott and Lowell.

Thank you livingston

Thank you livingston

Thanks you so much sean.Thanks alot

The wdate is the primary key column.

Thanks you sean lange for the quick replies.

you can use the wdate the first column for ordering.(May be i was given wrong sample data)

i want to set the Cdate seven days less than the rundate for the first Aid and 14 days less than the run date for the

second entry in the...

🙂 sry