国产一级a片免费看高清,亚洲熟女中文字幕在线视频,黄三级高清在线播放,免费黄色视频在线看

1.cinrad的中間狀態(tài)表,關(guān)機(jī)狀態(tài)記錄重做.

2.自動(dòng)氣象站中心站W(wǎng)eb版的功能需求,材料收集.

3.與Gst公司聯(lián)系briefnet相關(guān)事宜.

 

######################################

Z9834
Z9555
Z9476
Z9912
 
SQL> select radar_status,count(radar_status)
 from CINRAD_EVLUATION_INFO
 where stationnum =‘Z9834‘
 group by radar_status;

       1
       4
       3
       0

SQL> select distinct radar_status
  2  from CINRAD_EVLUATION_INFO
  3  where stationnum =‘Z9555‘;

           1

SQL> select distinct radar_status
  2  from CINRAD_EVLUATION_INFO
  3  where stationnum =‘Z9476‘;

           1

SQL> select distinct radar_status
  2  from CINRAD_EVLUATION_INFO
  3  where stationnum =‘Z9912‘;

           1
           4
           0

###################################
SQL> select radar_status,count(radar_status)
  2   from CINRAD_EVLUATION_INFO
  3   where stationnum =‘Z9834‘
  4   group by radar_status;

           1                   1
           4                  16
           3                   1
           0                 269

SQL> select radar_status,count(radar_status)
     from CINRAD_EVLUATION_INFO
     where stationnum =‘Z9912‘
     group by radar_status;

           1                   1
           4                   1
           0                 265

SQL> select radar_status,count(radar_status)
     from CINRAD_EVLUATION_INFO
     where stationnum =‘Z9555‘
     group by radar_status;
           1                 134

SQL> select radar_status,count(radar_status)
     from CINRAD_EVLUATION_INFO
     where stationnum =‘Z9476‘
     group by radar_status;

           1                 711

################################################
select status_time,radar_status
from CINRAD_EVLUATION_INFO
where stationnum=‘Z9476‘
and status_date=‘20070228‘
order by status_time;

update CINRAD_HIS_EVLUATION_INFO
set radar_status=‘4‘
where stationnum=‘Z9476‘
and status_date=‘20070228‘
and status_time>=‘151000‘;

select status_time,radar_status
from CINRAD_HIS_EVLUATION_INFO
where stationnum=‘Z9912‘
and status_date=‘20070228‘
order by status_time;

update CINRAD_HIS_EVLUATION_INFO
set radar_status=‘4‘
where stationnum=‘Z9912‘
and status_date=‘20070228‘
and status_time>=‘153000‘;

select status_time,radar_status
from CINRAD_HIS_EVLUATION_INFO
where stationnum=‘Z9551‘
and status_date=‘20070228‘
order by status_time;

update CINRAD_HIS_EVLUATION_INFO
set radar_status=‘4‘
where stationnum=‘Z9551‘
and status_date=‘20070228‘
and status_time>=‘150000‘;

select status_time,radar_status
from CINRAD_HIS_EVLUATION_INFO
where stationnum=‘Z9555‘
and status_date=‘20070228‘
order by status_time;

update CINRAD_HIS_EVLUATION_INFO
set radar_status=‘4‘
where stationnum=‘Z9555‘
and status_date=‘20070228‘
and status_time>=‘154000‘;

update CINRAD_HIS_EVLUATION_INFO
set radar_status=‘5‘
where stationnum=‘Z9453‘
and status_date=‘20070228‘
and status_time>=‘151000‘;

update CINRAD_HIS_EVLUATION_INFO
set radar_status=‘4‘
where stationnum=‘Z9532‘
and status_date=‘20070228‘
and status_time>=‘150000‘;

update CINRAD_HIS_EVLUATION_INFO
set radar_status=‘4‘
where stationnum=‘Z9834‘
and status_date=‘20070228‘
and status_time>=‘154000‘;

update CINRAD_HIS_EVLUATION_INFO
set radar_status=‘4‘
where stationnum=‘Z9817‘
and status_date=‘20070228‘
and status_time>=‘145000‘;

#################################
更新實(shí)時(shí)表中的
Z9555
Z9476

select count(*) from CINRAD_EVLUATION_INFO
where STATIONNUM = ‘Z9555‘;
delete from CINRAD_EVLUATION_INFO
where STATIONNUM = ‘Z9555‘;
insert into CINRAD_EVLUATION_INFO
(select * from CINRAD_HIS_EVLUATION_INFO
where STATIONNUM = ‘Z9555‘
and status_date > ‘20070225‘);

select count(*) from CINRAD_EVLUATION_INFO
where STATIONNUM = ‘Z9476‘;
delete from CINRAD_EVLUATION_INFO
where STATIONNUM = ‘Z9476‘;
insert into CINRAD_EVLUATION_INFO
(select * from CINRAD_HIS_EVLUATION_INFO
where STATIONNUM = ‘Z9476‘
and status_date > ‘20070225‘);

 

本站僅提供存儲(chǔ)服務(wù)，所有內(nèi)容均由用戶發(fā)布，如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容，請點(diǎn)擊舉報(bào)。