Need help on query
-
In 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 stuck
-
Sorry 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 Parmar
--------------------------------------------------------------------------------
Mayank Parmar
Software EngineerClarion Technologies
SEI CMMI Level 3 Company8th Floor, 803, GNFC info Tower,
SG Highway, Ahmedabad - 380 054,
Gujarat, India.
www.clariontechnologies.co.inEmail: mayank.parmar@clariontechnologies.co.in
MSN : mayank.parmar@clariontechnologies.co.in
Mobile: +91 9727748789
-------------------------------------------------------------------------------- -
Heh... "CE" must stand for "Crippled Edition".
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply