how to retrive latest date from mysql table

[selvialagar]

i have a date field in a table..i want to retrieve the data with latest date...is there any query for that.....

[debasisdas]

You want to reteive the row with latest date ?

[amitpatel66]

i have a date field in a table..i want to retrieve the data with latest date...is there any query for that.....

Are you looking at something like:

[code=mysql]

SELECT * FROM table_name1 WHERE date_column = (SELECT MAX(date_column ) FROM table_name1);

[/code]