MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Group By for a field but considering the latest
Posted by: Rick James
Date: October 26, 2016 09:11PM

SELECT vehicle, max(datetime) FROM tbl GROUP BY vehicle

If that is not what you want, please make the question clearer.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Group By for a field but considering the latest
Julio Albuquerque
October 25, 2016 05:36AM
Re: Group By for a field but considering the latest
Peter Brawley
October 25, 2016 10:08AM
Re: Group By for a field but considering the latest
Rick James
October 26, 2016 09:11PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.