今天写了很多简单的SQL

delete from tai_rtkpimarkgroup where kpi_id = 82202

insert into Tai_rtKpi_KpiValid values(62202)

select * from tai_rtkpi_dymmark where kpi_id = 82202

select distinct m.ne_id ne_id,obj.userlabel ne_name,a.kpi_id kpi_id,a.kpi_zhname kpi_zhname,m.kpi_value kpi_value,m.scan_start_time scan_start_time,a.kpi_format kpi_format,  0 sort from tpd_msc_hw m,tai_rtkpis a,objects obj where m.ne_id=obj.int_id and m.kpi_id=a.kpi_id and m.scan_start_time between '2007-10-01 00:00:00' and '2007-10-05 00:00:00' and m.ne_id = -965553159 and m.kpi_id=80402 order by sort, kpi_zhname, scan_start_time

......so simple~yeah~