sql查询重复的数据

--查询重复的数据
select * from stu where Code in
(
select Code
from  stu
group by Code,Name
having Count(ID) > 1
)
and Name in
(
select Name
from  stu
group by Code,Name
having Count(ID) > 1
)
--用重复的字段分组，不重复的字段Count
--第二种 只能查询出Code这一个字段重复的数据
select * from stu where Code=
 (
  select Code from stu
  group by Code
  having Count(Code)>1
)

转载于:https://www.cnblogs.com/kuang/archive/2012/07/19/2599340.html