oracle Group by 分組查詢後，分頁

標籤：

public Map getInWareHouseReport(int i, int j, InWareHouse inWareHouse) {
        //查詢分組後總條數
        String countquery="select WS_SKU_ID,sum(IN_NUMBER),sum(WH_MONEY) from IN_WAREHOUSE p group by WS_SKU_ID";
        //計算結束行
        int m=i+j;
        //分組分頁查詢
        String sqlString="select * from

(SELECT rownum as rn, a.* FROM (select WS_SKU_ID,sum(IN_NUMBER),sum(WH_MONEY) from IN_WAREHOUSE p group by WS_SKU_ID ) a)

where rn>"+i+" and rn<="+m+"";

        List trList = this.excuteSql(sqlString, "inreport");
        List clist = this.excuteSql(countquery, "count");
        int totalProperty = clist.size();
        Map map = new HashMap();
        map.put(TOTAL_PROPERTY, totalProperty);
        map.put(BUSI_LIST, trList);
        return map;
    }

oracle Group by 分組查詢後，分頁