MySQL Forums
Forum List  »  MySQL Query Browser

QUERY rank in query result
Posted by: george duran
Date: December 27, 2011 09:34PM

hi i have this table, i want to get the ranking according to the formula

(ID + (ID WITH THE SAME SCORE AS PREVIOUS ID)/NUMBER OF OCCURENCE)

and display it according to display below.

id name score -> rank
1 A 50 -> 1.5
2 B 50 -> 1.5
3 C 49 -> 3
4 D 47 -> 4
5 E 45 -> 5
6 F 43 -> 7
7 G 43 -> 7
8 H 43 -> 7


i have this problem almost 5 days now...please any help would be appreciated...thanks

Options: ReplyQuote


Subject
Written By
Posted
QUERY rank in query result
December 27, 2011 09:34PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.