Query Most Recent Date

[Guest_imported]

I have a query written to extract records for customers. When ever a change is made is writes to a new row for record retension. I would like to only receive the most recent date from that column. Can any one help with this scripting????

 

[foxdev]

Do you want only the one record with the most recent date, or do you want the record with the most recent date for a specific condition, such as a particular customer?

A) [tt]select top 1 * from MyTable
order by MyDateColumn desc[/tt]

or

B) [tt] select top 1 * from MyTable
where CustomerID = 'MyCustID'
order by MyDateColumn desc[/tt]
Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com