Select book_id,log, RANK() OVER(PARTITION BY book_id ORDER BY log DESC)  rank from admin_comments_tbl;

receive a error:0   8   11:12:48    Select book_id,log,
 rank() over(PARTITION BY book_id ORDER BY log DESC) as rank from admin_comments_tbl    Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(PARTITION BY book_id ORDER BY log DESC) as rank from admin_comments_tbl' at line 2    0.046 sec