SQL : How to use sql to retrieve the latest date?

Discussions

Web tier: servlets, JSP, Web frameworks: SQL : How to use sql to retrieve the latest date?

  1. SQL : How to use sql to retrieve the latest date? (1 messages)

    I wrote some jsp that retrive some data from a database table. In my table,i have several columns , one of which is date column(of type DATE) ...How do i retrive the row of the latest date? using MAX() function?I try it , but cant seem to work.

    BTW:Me using mysql.
  2. select * from table where datecol=max(datecol)

    steve - http://www.fdsapi.com - Possibly the easiest way to generated dynamic text including HTML and XML. Check out the live demo available from this site.