8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for SUM Analytic Function


Anonymous said...

Are those running totals correct? It seems that rows 7788 Scott & 7521 Ward aren't quite right.
+4875 = 10875 which is the same total as the previous row; also +1250 = 3450

Tim... said...

Hi.

It's using RANGE BETWEEN, so it's a reporting range. It includes all rows of the same value, even those beyond the current row. You will see if it is swapped to ROWS BETWEEN, the running totals will look "correct". So it is the correct answer for question being asked, but the question being asked is not the question you think it is. :)

Cheers

Tim...

Tim... said...

Hi.

I added another example. I think it might help.

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.