insert into table dw_access_dcip partition(prtflag_day=’18/Sep/2013’)
select b.remote_addr,b.firt_req_time,b.last_req_time,b.stay_long,a.acc_counts from
(select remote_addr,count(remote_addr) as acc_counts from dw_access_info where prtflag_day=’18/Sep/2013’ group by remote_addr having acc_counts<2) a
join
dw_access_info b
on a.remote_addr = b.remote_addr;