【Vegas原创】用虚拟表删除多条重复数据_java

select * into #tmp from trvperson 
group by id,parentID,tableName,url,target,expanded 
having count(id)>1

delete trvperson where id in(select id from #tmp)

insert into trvperson
select * from #tmp

drop table #tmp