摘要： SELECT 字段1,字段2,new_rank as rank from (SELECT 字段1,字段2,IF(@tmp=字段1,@rank:=@rank + 1,@rank:=1) as new_rank,@tmp:=字段1 as tmpFROM 表名ORDER BY 字段1 DESC) bwhe 阅读全文