create table dali.b as select * from a where (substr(id,1,6)='330206' and in_time>'200310070000' and in_time<'200310090000') or (substr(id,1,6)='330282' and in_time>'200310100000' and in_time<'200310130000')???
第二步:select * from b where id_code in (select id_code from b group by id_code having count(*)>1)
select * from a where (substr(id,1,6)='330206' and in_time>'200310070000' and in_time<'200310090000')
or (substr(id,1,6)='330282' and in_time>'200310100000' and in_time<'200310130000')???