Discussions

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

Bookmark and Share Get thread feed

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

    • Posted by: Han Chee
    • Posted on: December 06 2003 11:43 EST
    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.
    Reply to this

    Threaded Messages (1)

  2. SQL : How to use sql to retrieve the latest date?[ Go to top ]

    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.
    Reply to this Reply to original