The solution varies by database, which one are you using?

This would would work on MSSQL
SELECT TOP 1 *
FROM your_table_name
ORDER BY updated_date DESC

On Fri, Feb 15, 2008 at 8:40 AM, Scott Stewart <[EMAIL PROTECTED]>
wrote:

> Hey all,
>
>
>
> I have a query that returns a list of dates, how would I find the most
> recent. to post as "Last Updated"
>
>
>
> Thanks
>
>
>
> sas
>
>
>
> --
>
> Scott Stewart
>
> ColdFusion Developer
>
>
>
> SSTWebworks
>
> 4405 Oakshyre Way
>
> Raleigh, NC. 27616
>
> (919) 874-6229 (home)
>
> (703) 220-2835 (cell)
>
>
>
>
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.516 / Virus Database: 269.20.6/1280 - Release Date: 2/15/2008
> 9:00 AM
>
>
>
> 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299058
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to