How to Calculate Rank in oracle?

Hi,

I have a student table with columns, Student Id, Name, Group, Test Name and Marks.

Here, I would like to calculate rank based on marks. How can we do this in oracle?

Thanks in advance BI DWH BALA

asked Nov 27 '09 at 06:28 PM in Default

BI DWH BALA
606 ● 28 ● 40 ● 53

(comments are locked)

2 answers:

answered Nov 28 '09 at 02:04 AM

prodlife
201 ● 1

Yes Prodflife. Thanks a lot. It solved my issue.

Nov 29 '09 at 06:21 PM BI DWH BALA

(comments are locked)

select *, dense_rank() over (order by marks) from student

answered Aug 18 '10 at 07:18 AM

(comments are locked)

Your answer

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Follow @Ask_SSC

Topics:

asked: Nov 27 '09 at 06:28 PM

Seen: 1159 times

Last Updated: Jan 05 '10 at 05:34 PM