Skip to content
Advertisement

Oracle sum group by column range with different starting points

I have below sample data. i want to find the total sum(amount) of each respective user_x but starting from sdate assigned to each user. the sdate in the respective users does not change

What i have tried below returns all the results, i just want one line result for each user_x

This is what i want

How can i do this, also efficiently.

Advertisement

Answer

You seem to want:

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement