diff --git a/casic-metering-dao/src/main/resources/mapper/customer/CustomerSampleMapper.xml b/casic-metering-dao/src/main/resources/mapper/customer/CustomerSampleMapper.xml
index 1708c25..8e08174 100644
--- a/casic-metering-dao/src/main/resources/mapper/customer/CustomerSampleMapper.xml
+++ b/casic-metering-dao/src/main/resources/mapper/customer/CustomerSampleMapper.xml
@@ -190,11 +190,15 @@
     </select>
 
     <sql id="Sample_Testing">
-        (SELECT sample_id
-        FROM business_lab_executive_info
-        WHERE  measure_status = '3'
-            OR measure_status = '4'
-            OR measure_status = '5')
+        (
+            SELECT sample_id
+			 FROM (
+					 SELECT sample_id,measure_status,Max(create_time)
+					 FROM business_lab_executive_info
+					 GROUP BY sample_id,measure_status
+				  ) bo
+              WHERE measure_status= '5'
+        )
     </sql>
 
 </mapper>