Need help on query

Question

Post reply

Need help on query

miss.delinda

SSCommitted

Points: 1616
More actions
July 20, 2010 at 12:57 pm

#74302

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Mayank Parmar Ten Centuries Points: 1019 More actions · Answer 1

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 Engineer

Clarion Technologies
SEI CMMI Level 3 Company

8th Floor, 803, GNFC info Tower,
SG Highway, Ahmedabad - 380 054,
Gujarat, India.
www.clariontechnologies.co.in

Email: mayank.parmar@clariontechnologies.co.in
MSN : mayank.parmar@clariontechnologies.co.in
Mobile: +91 9727748789
--------------------------------------------------------------------------------

Jeff Moden SSC Guru Points: 1004309 More actions · Answer 2

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)