rafaelrgl
asked on
selecting rows base on sum of field
hi i have one table like this:
TBPRODUCT( ID AS INTEGER, PRODUCT AS STRING, PRICE AS DOUBLE )
this table have 500 rows and i want to select 6 products at a time that mach sum of price = 150.
and on the second time i select i don't want the same products i select on the first time.
how can i accomplish this?
TBPRODUCT( ID AS INTEGER, PRODUCT AS STRING, PRICE AS DOUBLE )
this table have 500 rows and i want to select 6 products at a time that mach sum of price = 150.
and on the second time i select i don't want the same products i select on the first time.
how can i accomplish this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER