标题: SQL查询倒入历史内涵临时表 [打印本页] 作者: hd87715 时间: 2018-7-14 23:17 标题: SQL查询倒入历史内涵临时表 select * into #vip_cf from 临时表
*********************************
select * into #vip_cf from from bas_vip
where vip_mobil_phone in (
select vip_mobil_phone from bas_vip group by vip_mobil_phone having count(*)>1
)