爱吃肉的熊猫

select count(distinct ex.C0007_SUBSTATION_ID) sum,ex.C0003_STNAME,ex.C0003_STCODE from V_WA_Exceed ex,t0003_station t3 where t3.c0003_stcode=ex.C0003_STCODE and             ex.C0001_ITEM_CODE in (

步骤：从第一到第四行SELECT SYSDATE FROM DUAL; //获取系统当前时间 SELECT to_char(SYSDATE,'yyyyMMdd') FROM DUAL; //格式化时间SELECT to_date(to_char(SYSDATE,'yyyyMMdd'),'yyyyMMdd') FROM DUAL; //获取到当天的0:00分SELECT to_dat