Oracle 语句整理

1  查出列当中重复的值

select ip2,count(*) from vm_info group by ip2 having count(*)>1

期中ip2为列名      vm_info为表名