Hello Kodular i am facing some issue in MySQL syntax In Rank Function . I was Using this syntax in Free Hosting Server (000Webshot) It Work But right now i brought paid hosting from godaday all syntax are working fine but rank Function i am getting some error.
I have Search Many forum But could not get the result so ask in kodular i know that their so much talented person have
Here Is my Table
So I am Used this query For get the user rank
SELECT Name, Score, TimeLeft, ProfilePic,DENSE_RANK() OVER (ORDER BY Score DESC , TimeLeft DESC) AS Rank FROM Contest1
I get the rank in 000webhost Mysql Server
IT WORK IN Free Hosting Mysql Database But Not Work In Godaddy Mysql Database
I have get this error in Godday Mysql Database