mysql - 选择MySQL中的重复记录

Question

此查询在 SQL Server 上有效，但在 MySQL 中不起作用。有人可以帮忙吗？

SELECT name 
FROM table_name 
WHERE 
   Institution_Code =  1  and 
   Month= 6 and Year= 2016 and 
  Id IN (
          SELECT Id FROM table_name 
          where Institution_Code =  1 and 
                Month= 6 and Year= 2016 
          GROUP BY Id HAVING count(Id) > 1 
        )

Answer 1

尝试转义查询中的保留字:

SELECT name 
FROM table_name 
WHERE Institution_Code = 1 
and `Month`= 6 
and `Year`= 2016 
and Id IN (
    SELECT Id 
    FROM table_name 
    where Institution_Code = 1 
    and `Month`= 6 
    and `Year`= 2016 
    GROUP BY Id 
    HAVING count(Id) > 1 )