InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 00:19:11 GMT20http://www.sqlservercentral.com/Forums/Topic955844-137-1.aspxHeh... "CE" must stand for "Crippled Edition". :-PFri, 26 Nov 2010 19:56:40 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic955844-137-1.aspxSorry for being late !!!For SQLCE, you can use either Exists or In operator:select * from t1 where maintdte not in (select MAX(maintdte) from t1) Regards,Mayank ParmarFri, 26 Nov 2010 02:30:17 GMTMayank Parmarhttp://www.sqlservercentral.com/Forums/Topic955844-137-1.aspxIn SQL Server below statement work fine,select * from t1 where maintdte != (select MAX(maintdte) from t1)How select * from t1 where maintdte != (select MAX(maintdte) from t1) looks like in SQLCE?I'm stuckTue, 20 Jul 2010 12:57:28 GMTmiss.delinda