How to select the rows with the maximum values ​​of one of the fields?

Question

SQL

Hello.
Given: view table

object	datetime	parameter
one	2013	one
2	2015	one
3	2015	one
4	2015	3
2	2016	one
3	2017	2

Please tell me how to select rows for distinct object where datetime will be maximum. Those. the result should look like this

object	datetime	parameter
one	2013	one
4	2015	3
2	2016	one
3	2017	2

Thank you.

Answer 1

SELECT `t`.*
  FROM (
    SELECT `object`, MAX(`datetime`) AS `maxtime`
    FROM `table`
    GROUP BY `object`
  ) AS `t1`
  JOIN `table` AS `t` ON `t`.`object` = `t1`.`object` 
    AND `t`.`datetime` = `t1`.`maxtime`