QUERY rank in query result
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
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.