select CQ_CODE,CQ_NAME,TO_PRESELL_ATEA,TO_SELLTS,
                 SOLD_EREA,SOLD_TS,SOLD_EVRPRICE,STAT_DATE,
                 YESTERDAY_SOLDTS,YESTERDAY_PRICE,YESTERDAY_AREA,
                 TODAY_SOLDTS,
    TODAY_PRICE,TODAY_AREA,yd_ts,yd_area, td_evrprice
     from
    (select CQ_CODE,WEBADMIN.get_dic_valuename(20,CQ_CODE) CQ_NAME,TO_PRESELL_ATEA,TO_SELLTS,
                 SOLD_EREA,SOLD_TS,SOLD_EVRPRICE,to_char(STAT_DATE,'YYYY,MM,DD') STAT_DATE,
                 YESTERDAY_SOLDTS,YESTERDAY_PRICE,YESTERDAY_AREA,TODAY_SOLDTS,
    TODAY_PRICE,TODAY_AREA,yd_ts,yd_area,
    round(nvl(TODAY_PRICE,0)/decode(nvl(TODAY_AREA,0),0,1,nvl(TODAY_AREA,0))) td_evrprice
from WEBADMIN.WEB_PRESELLSTAT_CUR where cq_code in(330108,330109,330110,330111,330112,330113,330114)
)
order by cq_code<br>[<strong>../file_html/temp/cq_330102.js</strong>]文件创建成功!<br>[<strong>../file_html/temp/cq_330103.js</strong>]文件创建成功!<br>[<strong>../file_html/temp/cq_330104.js</strong>]文件创建成功!<br>[<strong>../file_html/temp/cq_330105.js</strong>]文件创建成功!<br>[<strong>../file_html/temp/cq_330106.js</strong>]文件创建成功!<br>[<strong>../file_html/temp/cq_all.js</strong>]文件创建成功!