mysql 取下一行该列值_mysql – SQL：选择列值从上一行更改的行

SELECT a.*

FROM tableX AS a

WHERE a.StatusA <>

( SELECT b.StatusA

FROM tableX AS b

WHERE a.System = b.System

AND a.Timestamp > b.Timestamp

ORDER BY b.Timestamp DESC

LIMIT 1

)

但是，您也可以尝试这样做(使用(System，Timestamp)上的索引：

SELECT System, Timestamp, StatusA, StatusB

FROM

( SELECT (@statusPre <> statusA AND @systemPre=System) AS statusChanged

, System, Timestamp, StatusA, StatusB

, @statusPre := StatusA

, @systemPre := System

FROM tableX

, (SELECT @statusPre:=NULL, @systemPre:=NULL) AS d

ORDER BY System

, Timestamp

) AS good

WHERE statusChanged ;