SQL select only rows with max value on a column [duplicate]

Want to improve this post? Provide detailed answers to this question, including citations and an explanation of why your answer is correct. without enough detail may be edited or deleted. This question already has answers here: Retrieving the last record in each group – MySQL (32 answers) Closed 3 years ago. I have this table … Read more