SQL查询开始日期时间、结束日期时间、时差和特定ID的最后一行

Question

我有一个表如下

<表类> ID DateTime 总结 tbody><<tr>12022-06-21 19:03:30.783XSR12022-06-21 19:04:40.763GKE12022-06-21 19:05:35.483在22022-07-20 11:01:20.783基础代谢率22022-07-20 12:03:39.142/

试试这个:

SELECT 
t1.id, 
MIN(t1.[datetime]) AS [Starttime],
MAX(t1.[datetime]) AS [Endtime],
MAX(t2.summary) AS [Summary]
FROM Table t1, Table t2
WHERE t1.id = t2.id
AND t2.[datetime] = (SELECT 
MAX([datetime]) 
FROM Table t3
WHERE t2.id = t3.id)
GROUP BY t1.id
;