SQL Server - get latest date record

I have a log table.

I want to get record of latest date. Meaning if 1-May-2008 13:32:22 and 1-May-2008 2:22:21, it will retrieve 1-May-2008 13:32:22 as a result.

how the statement should be?

thaanks in advanced.

Whatever your datetime columnname is.

hi,

Let me know the coloumn name as to where your sotring the datwTime..

Example the coloumn name is  Date_time then  use this in your Query will be

  max(Date_time)

OR Use something like this:

SELECT     TOP 1 *  FROM  MyTable  ORDER BY DateField DESC

Here is another way to do it:

select * from MyTable where timestampfield = (select max(timestampfield) from MyTable)

Hi

select * from tablename where columnName = max(columnName )

useing this query you get the latest date for record

select  date  from Table where timestampfield = (select max(timestampfield) from Table)

For this you can use

1) TOP

2) ORDER BY

3) DESC

in combination to achieve this...

ex:

SELECT TOP 1 <column names> FROM LogTable ORDER BY logDate DESC

As Mr. Peter said use MAX function in query to get the latest date record.

select * from Employee where date = (select max(date) from table)

Hope this helps.

Thanks a lot
I tried the following example in the following link I have post in detail how we can use it --http://www.rajaramsystems.com/2010/08/18/max-date-in-sql-server/%