How do you write the SQL query the latest time of every group a.-CodePudding

Home > database > How do you write the SQL query the latest time of every group a.

How do you write the SQL query the latest time of every group a.

Time：11-19

Grouping query each time a new article,
The following results;

Id tname ttime
Beijing 2020-12-02 17:02:43
1 the 17:02:03 2020-11-11 in Shanghai