TOP 250 FROM A TABLE
Hello All,
There is a drug dispensing table which has rows like
patid1 drug1 qty1
patid1 drug2 qty2
patid2 drug1 qty1
patid2 drug3 qty3
How to find the top 10 drugs that were dispensed on the Quantity-Qty dispensed.
Thanks all.
There is a drug dispensing table which has rows like
patid1 drug1 qty1
patid1 drug2 qty2
patid2 drug1 qty1
patid2 drug3 qty3
How to find the top 10 drugs that were dispensed on the Quantity-Qty dispensed.
Thanks all.
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.
Looks like you chose the second answer.
btw When two answers are less than a minute or so apart and are identical, you could award all points to the first answer, but a split is also appropriate.
btw When two answers are less than a minute or so apart and are identical, you could award all points to the first answer, but a split is also appropriate.
You can request attention and have a moderator re-open the question so that you may allocate the points as you see fit.
ASKER