Home > IT Answers > SQL Server > SQL Server 2008 Finding Most Recent Record Only
Davewaltonuk
20 pts.
 SQL Server 2008 Finding Most Recent Record Only
SQL Record, SQL Server 2008, SQL Server Query
Hi there

I have a databse that logs letter print activity

The fields being

Letter_Ref

Print_date

Any time someone prints a particular letter it leaves a date in print ref

What i want to do is find the most recent print date for each letter_ref

is this possible and if so how



Software/Hardware used:
SQL Server 2008
ASKED: July 12, 2010  9:26 AM
UPDATED: July 12, 2010  4:21 PM
RELATED QUESTIONS
Answer Wiki:
<pre>SELECT Letter_Ref, MAX(Print_date) FROM YourTable GROUP BY Letter_Ref</pre>
Last Wiki Answer Submitted:  July 12, 2010  2:44 pm  by  carlosdl   63,580 pts.
All Answer Wiki Contributors:  carlosdl   63,580 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _