关于表重复数据

//查询重复数据
select * from T_BBXY_STUDENTFEES a where (a.CLASSID||a.STUDENTID) in (select CLASSID||STUDENTID from T_BBXY_STUDENTFEES group by CLASSID,STUDENTID having count(*) > 1)

//oracle
//删除重复数据留rowid最小
delete from T_BBXY_STUDENTFEES a
where a.OTH5 like ’ 18%’ and (a.CLASSID||a.STUDENTID) in
(select CLASSID||STUDENTID from T_BBXY_STUDENTFEES where OTH5 like ’ 18%’ group by CLASSID,STUDENTID having count() > 1)
and rowid not in (select min(rowid) from T_BBXY_STUDENTFEES where OTH5 like ’ 18%’ group by CLASSID,STUDENTID having count()>1)