Previous row value compare current sum (input -need output)

User_VK4XD

based on id Colums having ID(22201 having two payments 1275+1325=2600 like that i want output using sql )

mathguy

select id, payment, case row_number() over (partition by id order by payment)
                           when 1 then sum(payment) over (partition by id)
                                  else 0 end as total
from   input_data
order  by id, payment, total desc  -- if needed
;

SUM is a reserved keyword, you can't use it as column name in the output. (Technically you can, but you shouldn't.)

User_VK4XD

Plz help me quey fro me

mathguy

select id, payment, case row_number() over (partition by id order by payment)
                           when 1 then sum(payment) over (partition by id)
                                  else 0 end as total
from   input_data
order  by id, payment, total desc  -- if needed
;

SUM is a reserved keyword, you can't use it as column name in the output. (Technically you can, but you shouldn't.)