这sql怎么写 查询每个分组时间最新的一条。

[nitaiyoucala]

查询每个分组时间最新的一条。
需要下面结果；

id tname ttime
3 北京 2020-12-02 17:02:43
1 上海 2020-11-11 17:02:03

[二月十六]

SELECT MIN(id) id,
       tname,
       MIN(ttime) ttime
FROM 表
GROUP BY tname
ORDER BY id DESC

[雨夹雪]

SELECT a.* FROM 表 a INNER JOIN (SELECT tname,MAX(ttime) AS ttime FROM biao GROUP BY tname ) b ON a.tname=b.tname AND a.ttime=b.ttime

[wwfxgm]

都写得很好，学习了。

[北冥小渔夫]

SELECT id,tname,ttime FROM (SELECT *,ROW_NUMBER() OVER(PARTITION BY tname ORDER BY ttime DESC ) rn FROM 表名) _t
WHERE rn = 1

[Rebas1996]

SELECT id,
       tname,
       any_value(ttime) ttime
FROM t2
GROUP BY tname
ORDER BY id DESC