question

BI DWH BALA avatar image
BI DWH BALA asked

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

queryoraclerank
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

prodlife avatar image
prodlife answered
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

BI DWH BALA avatar image BI DWH BALA commented ·
Yes Prodflife. Thanks a lot. It solved my issue.
0 Likes 0 ·
swati avatar image
swati answered

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

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.