Rank function in mysql

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

Tags: MySQL