27,579
社区成员
发帖
与我相关
我的任务
分享
WITH CTE
AS
(SELECT *,
ROW_NUMBER() OVER (PARTITION BY 设备ID,CONVERT(VARCHAR(10),记录时间,23) ORDER BY 设备温度A DESC) AS SEQ_1,
ROW_NUMBER() OVER (PARTITION BY 设备ID,CONVERT(VARCHAR(10),记录时间,23) ORDER BY 设备温度B DESC) AS SEQ_2
FROM TABLE)
SELECT * FROM CTE
WHERE SEQ_1=1 OR SEQ_2=1