christheprogrammer
Programmer
Hey all,
I have a table with two fields, one is a species code and another is the weight of that species that has been caught (fish). I also have a total weight of all species of fish caught and I need to determine the species which make up 95% of the catch...
Table:
species_code weight
111 123
201 321
222 187
hundreds more....
now say my total weight of catch is 3000
How do I get the list of species whose weights make up 95% of 3000?
Cheers and Thanks in advance
Later
I have a table with two fields, one is a species code and another is the weight of that species that has been caught (fish). I also have a total weight of all species of fish caught and I need to determine the species which make up 95% of the catch...
Table:
species_code weight
111 123
201 321
222 187
hundreds more....
now say my total weight of catch is 3000
How do I get the list of species whose weights make up 95% of 3000?
Cheers and Thanks in advance
Later