Rank function in mysql

Question

1.00/5 (1 vote)

See more:

sir/mam can I know how can I get the rank function in my SQL
I have tried in my SQL this the code I have tried but its showing error plz help me
SELECT subjects,names, marks, rank()
over ( partition by subjects order by marks desc )
AS 'rank' FROM result;
many people are saying that there is no over clause function in MySQL so how can i get rank function sir

What I have tried:

SELECT subjects,names, marks, rank() 
over ( partition by subjects order by marks desc ) 
AS 'rank' FROM result;
many people are saying that there is no over clause function in MySQL so how can i get rank function sir

Posted 24-Apr-19 2:05am

Nayeeni Manoj

Updated 24-Apr-19 9:26am

Add a Solution

Comments

[no name] 24-Apr-19 8:35am

a.) "it is showing error" ---> What is the error?
b.) One of the mySQL Tutorial: A Guide to MySQL RANK Funtion By Practical Examples[^]

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Accepted Answer · 2019-04-24T02:32:00

Just get the syntax right - see the documentation A Guide to MySQL RANK Funtion By Practical Examples[^]
Try this

SQL

SELECT subjects,names, marks, rank() 
over ( partition by subjects order by marks desc ) my_Rank
FROM result;

I've removed the AS and given it a name that is not a reserved word.
If it still doesn't work then it's likely that you are using an out-of-date version of MySQL as the "many people" who are saying there is no over clause in MySQL are wrong.

Maciej Los · Accepted Answer · 2019-04-24T09:27:00

Solution 2

Depending on MySql database version ranking functions may not be available... See: MySQL :: MySQL 8.0 Reference Manual :: 12.21.1 Window Function Descriptions[^]

In that case, check this:
mysql - Get the rank of a user in a score table - Database Administrators Stack Exchange[^]
Assigning Ranks - MySQL Cookbook [Book][^]

Posted 24-Apr-19 9:27am

Maciej Los

Comments

[no name] 24-Apr-19 15:37pm

Also good, a 5

Maciej Los 24-Apr-19 15:50pm

Thank you, Bruno.

Rank function in mysql

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Rank function in mysql

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us