Answer the question
In order to leave comments, you need to log in
Answer the question
In order to leave comments, you need to log in
SELECT `t`.`id`, `m`.`name`, `m`.`date`
FROM (
SELECT MAX(`date`) AS `date`, `name`
FROM `table`
GROUP BY `name`
) AS `m`
JOIN `table` AS `t`
ON `t`.`date` = `m`.`date` AND `t`.`name` = `m`.`name`
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question