按计数查询顺序

Question

ID 名称

• 1 Asd
• 2 Qwe
• 3 Asd
• 4 Asd
• 5 Qwe
• 6 Dsa

我需要一个查询按计数返回组顺序，例如；

ID 名称

• 1 Asd
• 2 Qwe
• 3 Dsa

Answer 1

试试这个可能会有帮助，

SELECT COUNT(Name) AS total, id, Name
FROM table_name
GROUP BY Name   
ORDER BY COUNT(Name) DESC;

Answer 2

SELECT @rownum:=@rownum+1  AS ID,
       NameList.iName
FROM 
      (SELECT DISTINCT iName, COUNT(iName) AS iCount 
       FROM people 
       GROUP BY iName 
       ORDER BY iCount DESC) NameList, 
      (SELECT @rownum:=0) r 

将此子查询更改

      (SELECT DISTINCT iName, COUNT(iName) AS iCount 
       FROM people 
       GROUP BY iName 
       ORDER BY iCount DESC)

为包含名称列表的表。

Answer 3

检查这个

SELECT id, Name FROM user
GROUP BY Name   
ORDER BY COUNT(Name) DESC;