Index: ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/service/RecyclingRecordListSqlGenerator.java
===================================================================
diff -u -r38085 -r38176
--- ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/service/RecyclingRecordListSqlGenerator.java	(.../RecyclingRecordListSqlGenerator.java)	(revision 38085)
+++ ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/service/RecyclingRecordListSqlGenerator.java	(.../RecyclingRecordListSqlGenerator.java)	(revision 38176)
@@ -275,7 +275,7 @@
 					+ orgUnitCodingFromSupplyRoomConfig
 					+ "' and " 
 					+ filterSql
-					+ ") AS RowConstrainedResult  WHERE RowNum BETWEEN ("+ this.end +" -  " + this.pageSize +") + 1 AND "+ this.end;
+					+ ") AS RowConstrainedResult  WHERE RowNum BETWEEN ("+ this.end +" -  " + this.pageSize +") + 1 AND "+ this.end +  " order by RowNum asc " ;
 		} else if (dbConnection.isOracle()) {
 			sql = "SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT r.*,p.applicationTime,p.type,p.remark,p.submitTime,p.recyclingStatus,p.specialInfection,p.operationRoom,p.patient,p.hospitalNumber,p.serialNumber "+ extraQuery +" FROM " + RecyclingRecord.class.getSimpleName() 
 					+ " r left join " + InvoicePlan.class.getSimpleName() + " p on r.recyclingApplication_id = p.id " + joinSqlOfUrgent
@@ -285,7 +285,7 @@
 					+ filterSql
 					+ " order by " + tousseMaterialsLostMustConfirmOrder + recyclingAmountNeedConfirmOrder+" r.recyclingTime desc) A WHERE ROWNUM <= "
 					+ end
-					+ ")WHERE RN >= " + start;
+					+ ")WHERE RN >= " + start + " order by RN asc ";
 		}
 		return sql;
 	}