Web tier: servlets, JSP, Web frameworks: SQL : How to use sql to retrieve the latest date?
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.
- Posted by: Han Chee
- Posted on: December 06 2003 11:43 EST
BTW:Me using mysql.
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.