查看用户1的最高分排行:
select count(1) num_of_ranking from max_score t1 inner join max_score t2 on t1.user_id=1 and (t1.max_score<t2.max_score or t1.max_score=t2.max_score and t1.create_date>=t2.create_date);
查看用户1的最高分排行:
select count(1) num_of_ranking from max_score t1 inner join max_score t2 on t1.user_id=1 and (t1.max_score<t2.max_score or t1.max_score=t2.max_score and t1.create_date>=t2.create_date);