常用SQL语句

1.查找表中多余的重复记录，重复记录是根据单个字段（ID）来判断：

1 SELECT * FROM Employee WHERE ID IN (SELECT ID FROM Employee GROUP BY Id HAVING COUNT(ID) > 1)