1.根据a列进行分组,然后取b列最新的一条数据,b列是时间类型
使用子查询和GROUP BY
SELECT yt.*
FROM your_table yt
INNER JOIN (
SELECT a, MAX(b) AS latest_b
FROM your_table
GROUP BY a
) AS latest_times ON yt.a = latest_times.a AND yt.b = latest_times.latest_b;
1.根据a列进行分组,然后取b列最新的一条数据,b列是时间类型
使用子查询和GROUP BY
SELECT yt.*
FROM your_table yt
INNER JOIN (
SELECT a, MAX(b) AS latest_b
FROM your_table
GROUP BY a
) AS latest_times ON yt.a = latest_times.a AND yt.b = latest_times.latest_b;