mysql - SQL 中的语法错误 SQL 状态 :42601

Question

我想列出2013年最常见的帖子历史类型的id。

我的代码只计算每种类型出现的频率是正确的:

SELECT  COUNT(id)  FROM post_history WHERE year = 2013 GROUP BY post_history_type_id ORDER BY COUNT(id)

现在我想提取最大值并只显示它的 id。我试过这样:

SELECT MAX(SELECT  COUNT(id)  FROM post_history WHERE year = 2013 GROUP BY post_history_type_id ORDER BY COUNT(id);) FROM post_history ;

但他说以下错误:

FEHLER: Syntaxerror at „SELECT“ LINE 7: SELECT MAX(SELECT COUNT(id) FROM post_history WHERE year =... ^

********** Error**********

ERROR: Syntaxerror at „SELECT“ SQL Status:42601 Zeichen:255

希望你能帮助我:)

Answer 1

使用order by和limit:

SELECT post_history_type_id, COUNT(*)
FROM post_history
WHERE year = 2013
GROUP BY post_history_type_id
ORDER BY COUNT(*) DESC
LIMIT 1;