如何从mysql表中计算等级 [英] How to calculate Rank from mysql table

问题描述

可能重复:
MySQL排名函数

Possible Duplicate:
Mysql rank function

我在MySQL中有下表:

I have the following table in MySQL:

===================================================================
id  | member|  total_correct_question | time_taken_in_seconds |

===================================================================
1   |  abc  |     2                    |       4              |
2   |  def  |     3                    |       6              |
3   |  ghi  |     3                    |       4              |
4   |  jkl  |     3                    |       5              |
====================================================================

我想显示来自mysql查询的每个用户的排名.有人可以建议我对此进行查询吗?

I want to show the rank of each user from mysql query. Can any one suggest me a query for this?

推荐答案

尝试一下:

  SELECT @i:=@i+1 AS rank,a.*
  FROM
      (SELECT * 
       FROM   Your_table  
       ORDER BY total_correct_question DESC,
                time_taken_in_seconds)a,(SELECT @i:=0) r  

这篇关于如何从mysql表中计算等级的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！