我一直在使用mySQL进行操作,而COUNT函数却遇到了问题。我已经尝试删除空格,并且错误仍然存在。
SELECT COUNT(payment) FROM paymentType
GROUP BY payment
ORDER BY COUNT (payment) DESC
LIMIT 1;
我正在尝试在表
payment
中找到最常见的paymentType
条目。 最佳答案
如果您想要最普通的付款,那么我认为您想要:
SELECT payment
FROM paymentType
GROUP BY payment
ORDER BY COUNT(*) DESC
LIMIT 1;
关于mysql - MySQL错误-COUNT不存在,错误1630,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/53747554/