mysql order by count - 按值排序

Question

我试图通过对数据库中的记录进行分组来计算它们的数量。这工作正常，但是当我尝试排序时，它通过与想要的不同的方法排序计数。示例结果:

Question - Answer - Count

Q1 - A1 - 1

Q2 - A2 - 11

Q3 - A3 - 2

想要的结果:我想要 2-9 之后的 11，而不是之前的。查询很简单:

SELECT Question, Answer, count(*) as `Count` GROUP BY Question, Answer ORDER BY Question, Answer

该排序的另一个示例是 mysql 排序为 1,11,118,12,2,3，其中我期望递增的值如 1,2,3,11,12,118

Answer 1

试试这个查询

SELECT Question, Answer, count(*) as `Count`
FROM table
GROUP BY Question, Answer
ORDER BY count(*) ASC