select problem

hastikeyvan · May 17th, 2008, 01:57 AM

Hell all
Is there any one can help me to write a select statement in SQLServer2000 like this:
Select * from tb1 where Project='a' and UpdateDate=(Select * from tb1 where Project='a' and UpdateDate=Max(UpdateDate))
Thank you for your help.
Hasti Keyvan

joefawcett · May 17th, 2008, 02:18 AM

If you want the data where Project = 'a' and the UpdateDate is the latest then you need:

Code:

SELECT * from tb1 WHERE Project='a' and UpdateDate = 
(SELECT MAX(UpdateDate) FROM tb1 WHERE Project = 'a');

Alternatively you could use a join instead of a subquery.
If that's not what you wanted then explain further.

--

Joe (Microsoft MVP - XML)

hastikeyvan · May 17th, 2008, 03:13 AM

Dear joefawcett
Thank you for your kindly help.That's exactly was I needed.