rank [message #634121] |
Wed, 04 March 2015 11:34 |
kilimanjaro
Messages: 151 Registered: May 2009 Location: Tanzania
|
Senior Member |
|
|
Hello,
The below query fetches students and their correspondent ranking in terms of max achieved and it does so as I wanted. The problem is I want to fetch specific student and the rank .It doesn't give me the results even when using the parameter =:STUDENT_NUMBER. In all scenarios it returns position(PS) = 1.
select distinct student_name, event_number ,MAX_ATTAINED,grade,milestone,DENSE_RANK() OVER (PARTITION BY event_number ORDER BY MAX_ATTAINED DESC ) PS from examination3
--where student_name=:STUDENT_NUMBER)
Thank you.
|
|
|
Re: rank [message #634125 is a reply to message #634121] |
Wed, 04 March 2015 12:52 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
Your question is not clear, but it remotely resembles a question that I would suggest to use a SELECT of a resultset.
|
|
|
|
Re: rank [message #634131 is a reply to message #634128] |
Wed, 04 March 2015 13:41 |
kilimanjaro
Messages: 151 Registered: May 2009 Location: Tanzania
|
Senior Member |
|
|
Thank you all for quick reply.This is the scenario.
I have an examination table with,three columns: max_achieved,class_code,student_number.
Now I want to rank students based on the max_achieved and class code for individual reports. I hope this is clear.
Thank you all for assistance.
|
|
|
|
|
|
|
Re: rank [message #634848 is a reply to message #634794] |
Mon, 16 March 2015 15:22 |
Bill B
Messages: 1971 Registered: December 2004
|
Senior Member |
|
|
select student_name,student_number,class_code,max_achieved,rnk
from
(select student_name,student_number,class_code,max_achieved,DENSE_RANK() OVER (PARTITION BY class_code ORDER BY max_achieved DESC ) as rnk
from examination)
where student_number = 123;
|
|
|