Index: lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20130812.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20130812.sql,v
diff -u -r1.1 -r1.2
--- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20130812.sql	12 Aug 2013 16:29:02 -0000	1.1
+++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20130812.sql	27 Aug 2013 10:22:39 -0000	1.2
@@ -4,13 +4,16 @@
 ----------------------Put all sql statements below here-------------------------
 
 --LDEV-3085 Autosave feature for MCQ
-DELETE FROM tl_lamc11_usr_attempt WHERE uid NOT IN ( --remove all attempts except the last one 
+DELETE FROM tl_lamc11_usr_attempt WHERE uid NOT IN ( 
   SELECT uid
   FROM (
-    SELECT uid
-    FROM tl_lamc11_usr_attempt
-    ORDER BY attemptOrder DESC
-    LIMIT 1
+	SELECT attempt.uid
+	FROM tl_lamc11_usr_attempt attempt
+	INNER JOIN(
+	    SELECT que_usr_id, mc_que_content_id, max(attemptOrder) attemptOrder
+	    FROM tl_lamc11_usr_attempt
+	    GROUP BY que_usr_id, mc_que_content_id
+	) ss ON attempt.que_usr_id = ss.que_usr_id AND attempt.mc_que_content_id = ss.mc_que_content_id AND attempt.attemptOrder = ss.attemptOrder
   ) foo
 );
 ALTER TABLE tl_lamc11_usr_attempt DROP COLUMN attemptOrder;