Query on how to Select Date before the latest Date in MySQL

Query on how to Select Date before the latest Date in MySQL



I need help on mysql query with regards to date.

I want to select the date before the latest date in mysql query. For

example the dates are:

2013-01-29, 2013-02-28, 2013-03-29

The output must be 2013-02-28.

What sql clause must be used to return the said output?

Thanks in advance.