Defry

摘要： 1 分析函数 相当于把分组后的结果加到每一行里 SELECT t.loan_contract_no,t.loan_name,t.loan_amount,ROWNUM, row_number() over (PARTITION BY t.area_no ORDER BY t.loan_amount D 阅读全文

摘要： st = conn.prepareStatement(sql.toString(), ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); str=DataUtil.resultSetToArray(st.executeQue... 阅读全文