I'm using MySql 5.0 as i search the internet i can see many people talking about the rank function but as i try it on MySql 5.0 which I'm using it doesn't really work. For example:
SELECT RANK() OVER (order by total_time desc)as rank , id ,first name ,last name
from user_tbl;
But this line of query doesn't work
Asked
Active
Viewed 442 times
-2
-
3Possible duplicate of [Rank function in MySQL](http://stackoverflow.com/questions/3333665/rank-function-in-mysql) – Shadow May 23 '16 at 16:14
-
mysql does not have a rank() function. – Shadow May 23 '16 at 16:15
-
i only want to display the rank of the last user(id) can anyone please help – Suni May 23 '16 at 16:23
1 Answers
0
MySQL does not support RANK() function, or any of the other analytic functions supported by other databases like Oracle and SQL Server.
spencer7593
- 103,596
- 14
- 107
- 133