03 2014 档案

摘要:简单的让你无法想象!处理方法:在环境变量中新增系统变量以下变量值对:变量名:NLS_LANG变量值:AMERICAN_AMERICA.ZHS16GBK好了 阅读全文
posted @ 2014-03-19 17:46 醉洒脱 阅读(2369) 评论(0) 推荐(0)
摘要:1. 全选的checkbox选中时,子checkbox全部选中。反之,全部不选2.子checkbox中,只要有没有被选中的,取消全选checkbox的选中3.子checkbox的数量和子checkbox被选中的数量一样时,全选checkbox要被选中$("input:checkbox) 相当于$("input[type='checkbox'])[javascript] //全部选择 $("#checkall").click(function(){ $("input:checkbox[name='checkbox[] 阅读全文
posted @ 2014-03-14 11:00 醉洒脱 阅读(320) 评论(0) 推荐(0)
摘要:SELECT supplier_id, max(evidence_date) AS evidence_date,max(TD_SUPPLIER_EVIDENCE_INFO_ID) AS TD_SUPPLIER_EVIDENCE_INFO_ID FROM TD_SUPPLIER_EVIDENCE_INFO GROUP BY supplier_id ORDER BY evidence_date desc;使用group by 查询字段需要 max min avg count sum 等方法控制 阅读全文
posted @ 2014-03-11 17:38 醉洒脱 阅读(404) 评论(0) 推荐(0)
摘要:SELECT distinct supplier_id, min(evidence_date) as evidence_date FROM TD_SUPPLIER_EVIDENCE_INFO where VERIFIER = 'gaoyinghui' group by supplier_id order by evidence_date desc; 阅读全文
posted @ 2014-03-07 11:14 醉洒脱 阅读(2042) 评论(0) 推荐(0)