query field relative to max date

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

query field relative to max date

Author

Topic

cray
Starting Member

9 Posts

Posted - 2005-11-10 : 17:11:46

How do I query to ONLY pull the location for the most recent date?

Date Location
1/2/97 ABC
3/4/02 DEF
2/8/89 GHI
4/30/05 JKL
2/28/03 MNO

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-11-10 : 17:18:10

It is not necessary to post your question more than once.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=57589

Tara Kizer
aka tduggan

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources