Eric Bourland
asked on
how to select only the single, most recent data record?
ColdFusion 9
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?
I've looked around, but no solution seems to exactly fit my requirement. Thank you as always.
Eric
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
FROM TIRBlog
WHERE blogDate (is the most recent date)
</cfquery>
I've looked around, but no solution seems to exactly fit my requirement. Thank you as always.
Eric
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That worked very well. Thank you,sajayc.
Your welcome!
ASKER