Hi, On Tue, Mar 4, 2008 at 10:57 AM, Esbach, Brandon <[EMAIL PROTECTED]> wrote: > > There is likely a blindingly obvious solution to this, I need to do a > group by expression in my query and get the latest row based on a date > field in the same table. > Is this even possible, and any tips on how to do that?
Sure. Two posts that ought to cover your question: http://www.xaprb.com/blog/2006/12/07/how-to-select-the-firstleastmax-row-per-group-in-sql/ http://www.xaprb.com/blog/2007/08/21/how-to-select-the-first-or-last-row-per-group-in-sql/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]