mysql - 如何查找发布最多事件的人

Question

我正在使用mysql。这是我的sql

  SELECT LIMIT 1
   users.id,
   COUNT(events.id) AS events_count
  FROM
   INNER JOIN 'events' ON users.id = events.user_id
  GROUP BY
    users.id
  ORDER BY
   COUNT(events.id) DESC

这是我收到的错误

Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INNER JOIN 'events' ON users.id = events.user_id
      GROUP BY
        users.id' at line 5: 
      SELECT
       users.id,
       COUNT(events.ID) AS events_count
      FROM
       INNER JOIN 'events' ON users.id = events.user_id
      GROUP BY
        users.id
      ORDER BY
       COUNT(events.id) DESC

Answer 1

您似乎在 FROM 子句后缺少表名。此外，您的 LIMIT 语法也是错误的。看这里引用http://dev.mysql.com/doc/refman/5.1/en/select.html

SELECT 
  users.id,   
  COUNT(events.id) AS events_count  
FROM users
INNER JOIN events ON users.id = events.user_id  
GROUP BY    
  users.id  
ORDER BY   
  COUNT(events.id) DESC
LIMIT 1