first table is my input and expecting output like second table with out using left join.
this is the table data
declare @table table
INSERT INTO @table (
select * from @table order by customer_id,indicator desc
,sum(salary) OVER (PARTITION BY customer_id) p_salary
LEFT JOIN (
,sum(salary) OVER (PARTITION BY customer_id) n_salary
WHERE indicator = 0
) b ON a.customer_id = b.customer_id
order by customer_id,indicator desc
I think you want this:
select t.customer_id, t.indicator, sum(case when indicator = 1 then salary else - salary end) over (partition by customer_id) as netresult form @table t;
No joins are necessary.