查找重复列:
select * from ysgg where number in(select number from ysgg group by number having count(number)>1);
删除重复列:
delete from ysgg where number in (select min(number) from ysgg group by number having count(number)>1);
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/13545951/viewspace-539592/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
RMAN备份批处理 (转)
下一篇：
java日期加减法
请登录后发表评论
登录
全部评论
