mysql count 以 DESC 顺序返回多行

Question

我读过的计数只返回一行，但是如果你使用 group by 你可以得到多行返回

上面返回结果的代码是

SELECT event_id, COUNT( event_id ) AS nr FROM picks GROUP BY event_id DESC LIMIT 0 , 30

但是我现在需要找到一种方法来按 DESC 顺序对其进行排序。我试过 order by 但后来我只得到 1 行，看起来我不能将 DESC 与 group by 一起使用。寻求建议

更新

下面给出如下图所示的结果

SELECT event_id, COUNT( event_id ) AS nr
FROM  picks
GROUP BY event_id
Order by event_id DESC
LIMIT 0 , 30

Answer 1

降序

SELECT event_id, COUNT( event_id ) AS nr
FROM  picks
GROUP BY event_id
Order by event_id DESC
LIMIT 0 , 30

升序 //这是默认的排序顺序

SELECT event_id, COUNT( event_id ) AS nr
FROM  picks
GROUP BY event_id
Order by event_id
LIMIT 0 , 30