Date: 07/11/05 (MySQL Communtiy)    Keywords: no keywords

I need to search a table for the an item that matches the client_id and return the date of the most recent record (column is invoice_date and the format is yyyy-mm-dd).

Is there a statement like MAX that I can use?

Thanks, I am currently searching the manual.

Source: http://www.livejournal.com/community/mysql/61823.html