我正在尝试获取不同表中的登录和计数,但它不起作用SELECT login AS "Login", COUNT(posted) AS "Nombre" FROM members,wallmsg;ERROR 1140 (42000): In aggregated query without GROUP BY, expression #1 of SELECTlist contains nonaggregate
我想创建一个返回所有person信息的查询,以及一个额外的字段,它告诉我们有多少人共享每个人的生日。在SQL中,我会这样写它:
SELECT p.name, b.count FROM persons as p INNER JOIN (SELECT birthday as date, COUNT(*)AS count FROM persons GROUP_BY birthday) AS b WHERE p.birth