Say I have a table with 3 columns: "Make", "Model", "SaleDate". I want to know, for each make, the most recent model that was sold. In other words "For each unique value of 'Make', sort all rows by 'SaleDate' descending, and return the value for 'Model' in the first row"
I have no idea how to write this query. Can it be done in MySql?
