SQL Server 2005
I need to query a data table and get back only the single, most recent data record. How can I do that?
<cfquery name="getmostrecentblogpost" datasource="#application.datasource#">
SELECT blogID, blogTitle, blogExcerpt, blogAuthor, blogDate
WHERE blogDate (is the most recent date)
I've looked around, but no solution seems to exactly fit my requirement. Thank you as always.