SQL语句：如何查询重复信息
SELECT * FROM TABLE WHERE NAME IN (SELECT NAME FROM TABLE GROUP BY NAME HAVING COUNT(*)>1)