SELECT R1.* FROM ( ) R1 LIMIT #{pgtl.startNo}, #{pgtl.listPerPage} select * from t_data_table_statistics where inputYear = #{inputYear} and inputMonth = #{inputMonth} order by inputMonth desc, inputYear desc, tableName asc select count(*) as count from ( ${map.queryString} ) a ${map.queryString} select s2.*, CEIL((s2.dataSize - s1.dataSize)/1000) as dataSizeDiff, (s2.dataRow - s1.dataRow) as dataRowDiff from ( select s2.* from t_data_table_statistics s2, ( select tableName, max(dataSize/1000) as dataSizeMax from t_data_table_statistics where inputYear=#{inputYear} and inputMonth=#{inputMonth} group by tableName order by dataSizeMax desc LIMIT 0, 20 ) s0 where s2.tableName = s0.tableName and s2.inputYear=#{inputYear} ) s2 left join t_data_table_statistics s1 on s2.inputYear = s1.inputYear and s2.inputMonth = (s1.inputMonth+1) and s2.tableName = s1.tableName order by s2.inputMonth asc, s2.tableName asc order by s2.tableName asc, s2.inputMonth asc