------快的
create table dc_proworktemp as
select PROSN from dc_prowork where to_char(prwwork,'YYYYMMDDhh24miss') BETWEEN '20051229090000' AND '20051229190000'
and prwstation='F260300' and matcode='BC09B201T00'select PROSN from dc_prowork where to_char(prwwork,'YYYYMMDDhh24miss') BETWEEN '20051229090000' AND '20051229190000'
and prwstation='F260100' and matcode='BC09B201T00' and prosn not in
(select PROSN from dc_proworktemp)------慢的
select PROSN from dc_prowork where to_char(prwwork,'YYYYMMDDhh24miss') BETWEEN '20051229090000' AND '20051229190000'
and prwstation='F260100' and matcode='BC09B201T00' and prosn not in
(select PROSN from dc_prowork where to_char(prwwork,'YYYYMMDDhh24miss') BETWEEN '20051229090000' AND '20051229190000'
and prwstation='F260300' and matcode='BC09B201T00')
create table dc_proworktemp as
select PROSN from dc_prowork where to_char(prwwork,'YYYYMMDDhh24miss') BETWEEN '20051229090000' AND '20051229190000'
and prwstation='F260300' and matcode='BC09B201T00'select PROSN from dc_prowork where to_char(prwwork,'YYYYMMDDhh24miss') BETWEEN '20051229090000' AND '20051229190000'
and prwstation='F260100' and matcode='BC09B201T00' and prosn not in
(select PROSN from dc_proworktemp)------慢的
select PROSN from dc_prowork where to_char(prwwork,'YYYYMMDDhh24miss') BETWEEN '20051229090000' AND '20051229190000'
and prwstation='F260100' and matcode='BC09B201T00' and prosn not in
(select PROSN from dc_prowork where to_char(prwwork,'YYYYMMDDhh24miss') BETWEEN '20051229090000' AND '20051229190000'
and prwstation='F260300' and matcode='BC09B201T00')
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货