select ip,count(*) as count from interface group by ip having count>1;查看 interface表中 ip字段重复的
select ip,count(*) as count from interface where port = "10050" group by ip having count>1;增加条件
上一篇:Oracle alter操作
下一篇:mybatis-oracle(ssi2)批量删除