Hello Tesu,

I found the answer. i have used alias name in the subquery.

Thank You.

Regards
Selva

Hello Tesu,

This is really helpful for my requirement. I am using the query

select id, mill_rate, mill_rate+coalesce((select sum(mill_rate)
from mdata b where b.id < a.id ),0) as sumMill
...