1delete 2FROM TestTable3WHERE (Userid NOT IN4 (SELECT Userid5 FROM (6 SELECT MAX(Userid) AS Userid FROM TestTable7 GROUP BY Userid) a))8