SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

A complex case to solve

Orcl ApexDec 7 2017 — edited Dec 11 2017

Hello Guys,

I have a data like shown below and I want as much as possible to find the best from a combination of these items and

ID TOTAL

1 25150

2 19800

3 27511

ID ITEM

1 7120

2 8150

3 8255

4 9051

5 1220

6 12515

7 13555

8 5221

9 812

10 6562

TOTAL SUM CALC

25150 25133 7120 + 8150 + 9051 + 812

19800 19768 1220 + 12515 + 5221 + 812

27511 27488 8150 + 8255 + 9051 + 1220 + 812

This post has been answered by mathguy on Dec 7 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 8 2018

Added on Dec 7 2017

46 comments

1,440 views