Combination Function [message #359911] |
Tue, 18 November 2008 15:07 |
jnwaima
Messages: 1 Registered: November 2008 Location: Texas
|
Junior Member |
|
|
I am new to PLSQL but I've been given a task to write a function that checks to see if there are more than 1 possible combination of transaction_ids whose total amount adds up to a specified amount.
e.g In my TRANSACTION TABLE
transaction_id AMOUNT
1111 $20.00
2222 $25.00
3333 $25.00
4444 $50.00
5555 $150.00
6666 $180.00
Charge is to find out if there is more than one possible combinations of transaction_ids that adds up to $200.00 (
e.g 25+25+150 or 50+150 or 20+180
If there is only one combination, then return the transaction Ids that adds up to $200.00
Any ideas or suggestions will be greatly appreciated.
Thanks,
J.
|
|
|