2016年6月29日
墓型价格分析表
摘要： SELECT t1.azfsmc AS AZFS, MIN (TO_CHAR (t1.rq, 'yyyy')) AS nd, t1.mxmc, t1.mj, MIN (t1.ssje) AS zx, MAX (t1.ssje) AS zd, TRUNC... 阅读全文
posted @ 2016-06-29 15:48 韩梦芫 阅读(168) 评论(0) 推荐(0) 编辑
用碑情况统计
摘要： INSERT INTO BUSINESS_EX_INFO SELECT SEQ_BUSINESSEXINFO_ID.NEXTVAL,ID,16,'是' FROM qtywb where (ywdm='12' OR YWDM='14') and zxflag'1'; --用碑数据-- SELECT ssrq, mx,sum(zys) as zys,sum(jgs) as jgs,sum(BQ... 阅读全文
posted @ 2016-06-29 15:47 韩梦芫 阅读(202) 评论(0) 推荐(0) 编辑
续租分析情况表
摘要： SELECT gmrq, SUM (zysl) AS zysl, SUM (tmsl) AS tmsl, SUM (qcsl) AS qcsl, SUM (qfsl) AS qfsl, SUM (xzsl) AS xzsl, SUM (jgsl... 阅读全文
posted @ 2016-06-29 15:46 韩梦芫 阅读(316) 评论(0) 推荐(0) 编辑
extjs分组查询
摘要： 阅读全文
posted @ 2016-06-29 15:20 韩梦芫 阅读(335) 评论(0) 推荐(0) 编辑