有Student数据库
第一种方法:
select * from Student where Sdept=(select Sdept from Student group by Sdept having count(*)>1)
若要查询数据库中重复记录,则需把其他字段添加到group by 里
第二种方法:
select distinct a.* from Student a ,Student b where a.Sno!=b.sno and a.Sdept=b.Sdept
若要查询数据库中重复记录,则需把其他字段添加到后面