Hello All,
I have a table that has a PartNumber and the Quantity of Items sold for each partNumber, that is:
PartNumber Qty
I need to get its sales raking given its PartNumber, that is. So if I order the table by Qyt in descending order the first
record will be the partNumber that sold the most. If I want to know what is 123 raking position according to that.
Is there any easy way to do it?
Thanks in advance.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
