SELECT id,LAG( taskstatus ) OVER ( ORDER BY taskdate ) AS prev_status from tablenamea
MYSQL查找某行前一行数据状态
于 2024-07-23 10:36:11 首次发布
SELECT id,LAG( taskstatus ) OVER ( ORDER BY taskdate ) AS prev_status from tablenamea