select vDate,distinct(ipaddress) from a where trunc(fildate,'dd') = vDate and ipaddress not in (select trim(ipaddress) from b) vDate> = vBEGINdate vDate<= vENDdate数据取到一张表里应该怎么写语句
什么意思?insert查询结果到一张表?create table xxxx as select * from ....这样?
insert into xxxx select * from ......这样?
select vDate,distinct(ipaddress) from a where trunc(fildate,'dd') = vDate and ipaddress not in (select trim(ipaddress) from b) VDATE 是变量 在一段时间里 我需要一段时间里每天的数据
VDATE 是变量 在一段时间里 我需要一段时间里每天的数据