Wed. Jul 22nd, 2026

分组后取时间最新的数据

SELECT max(Id)/*注意Id必须使用聚合函数Max*/ , Pid, MAX(Time) as MaxTime
FROM Test
GROUP BY pid

By kim

Leave a Reply