mysql - SQL 按组排序

Question

question category 
A           X
B           Y
C           X
D           X
E           Y

我想从最常见的类别中输出

question category
A             X
C             X
D             X
B             Y
E             Y

标签： mysqlsqlsql-order-by

Answer 1

您可以尝试加入类别计数

select m.question, m.category  
from my_table  m
inner join  (
  select category, count(*) num
  from my_table  
   group by category 
) t on t.category = m.category
order by t.num desc, m.category, m.question