php - php 中的 count 、 group by 和 Max

Question

我有

|name  | number |
|andi  | 40     |
|irfan | 30     |
|lia   | 60     |
|andi  | 50     |
|lia   | 10     |
|sali  | 60     |

我想按最大顺序显示

name   | number |
andi   | 90     |
lia    | 70     |
sali   | 60     |
irfan  | 30     |

我的代码如下所示:

SELECT name, 
       COUNT(name) 
FROM   tablename 
GROUP  BY name 
ORDER  BY MAX(number)

而且它不起作用。结果只是按名称工作组，而不是按最大数量进行缩短

name   | number |
lia    | 70     |
sali   | 60     |
andi   | 90     |
irfan  | 30     |

Answer 1

您必须执行Select * from tablename Order By Number DESC