如下图,查询出重复发放工资的员工: sql语句:SELECT * FROM a WHERE NAME IN (SELECT NAME FROM a GROUP BY NAME HAVING COUNT(NAME) > 1) 结果如下: