MySQL Forums
Forum List  »  Newbie

Group By for a field but considering the latest
Posted by: Julio Albuquerque
Date: October 25, 2016 05:36AM

Hello!
I have a table with the following fields: id, vehicle, datetime, value.
This table already has over two million records where the vehicle field is repeated.
I need to build a query that returns the group by a vehicle but that is as current as the datetime field.
How to make this query?

Options: ReplyQuote


Subject
Written By
Posted
Group By for a field but considering the latest
October 25, 2016 05:36AM


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.